CREATE CURSOR cTmp (Department i, FIO c( 10 ))

INSERT INTO cTmp VALUES ( 1 ,"AAA")
INSERT INTO cTmp VALUES ( 1 ,"BBB")
INSERT INTO cTmp VALUES ( 2 ,"CCC")
INSERT INTO cTmp VALUES ( 2 ,"DDD")
INSERT INTO cTmp VALUES ( 3 ,"EEE")

SELECT Department, COUNT(FIO) as Qty ;
	FROM cTmp ;
	GROUP BY Department ;
	INTO CURSOR cTmp2

SELECT * ;
	FROM cTmp2 ;
	WHERE Qty in (SELECT MAX(Qty) as Qty FROM cTmp2)

select * ;
   from НаучныеСпециальности ;
   where НаименованиеСпециальности not in (select dist НаименованиеСпециальности from Сотрудники)

select * ;
   from НаучныеСпециальности ;
   where НаименованиеСпециальности not in (select dist НаименованиеСпециальности from Сотрудники)

select * ;
   from Nauchn ;
   where Shifr not in (Select ShifrSpec from Sorudniki)

select nomerotdel, Count(iif(zvanie='proffessor', 1 , 0 )) as Proff, ;
   Count(iif(zvanie='docent', 1 , 0 )) as Docent ;
from sorudniki

select nomerotdel, Zvanie, Count(zvanie) as Qty ;
   from sorudniki ;
   group by nomerotdel, Zvanie ;
   order by nomerotdel, Zvanie