SELECT studID, firstname, lastname, depNo
FROM students
WHERE depNo in (select depNo
                            from students
                            group by depNo
                            having  count(studID)>10)
ORDER BY depNo;



SELECT round(avg(psychometric), 2) AS [פסיכומטרי ממוצע], round(avg(tuition), 2) AS [שכר ממוצע], depNo
FROM students
GROUP BY depNo
HAVING depNo in (select depNo
                            from students
                            group by depNo
                            having avg(tuition)>3000 and avg(tuition)<19500);