Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT imie, nazwisko, (SELECT COUNT(*) FROM studenci WHERE ocena=s AND lp<>s.lp) FROM studenci s WHERE miasto IN ("Tarnów","Krosno")
- SELECT imie, nazwisko, (SELECT COUNT(*) FROM studenci WHERE s.ocena=ocena)-1 FROM studenci s WHERE miasto IN("Tarnów","Krosno")
- SELECT COUNT(*) FROM studenci s WHERE miasto IN('Krosno','Tarnów') AND EXISTS (SELECT * FROM studenci WHERE ocena=s.ocena AND lp<>s.lp)
- SELECT * FROM pracownicy p WHERE PLACA_POD<(SELECT AVG(PLACA_POD) FROM pracownicy WHERE ID_ZESP=p.ID_ZESP)
- SELECT COUT(*) FROM uczniowie u WHERE NOT EXISTS (SELECT 1 FROM uczniowie NATURAL JOIN glosy WHERE u.id_ucznia=glosy.id_ucznia)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement