Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --1. Katere izpite in kdaj je opravil 'Jože Kos'?
- SELECT idIzpit,datum,ime
- FROM izpit i,student_has_izpit si, student s
- WHERE i.idIzpit=si.FK_izpit AND s.idStudent=si.FK_student
- AND s.ime="ime1" AND s.priimek="priimek1" AND i.ocena>5;
- --2. Koliko študentov ima predizobrazbo 'gimnazijski maturant'?
- SELECT COUNT(*)
- FROM student s, dosedanja_izobrazba di
- WHERE di.idDosedanja_izobrazba=s.FK_dosedanja_izobrazba
- AND di.naziv="naziv10";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement