SELECT SFAM FROM STUDENTS WHERE STIP IN (1200, 1300, 1500)

SELECT COUNT(*) FROM STUDENTS

SELECT SNOM FROM USPISH WHERE OCINKA IS NULL;

SELECT AVG(OCINKA) FROM USPISH GROUP BY SNOM

SELECT SUM(GOD) FROM PREDMET GROUP BY PNOM