2
SELECT A.DEPART, A.SEX, SUM(IIF(SEX='男',1,0)) AS 男, SUM(IIF(SEX='女',1,0)) AS 女
FROM (SELECT A.DEPART,A.SEX
FROM S a INNER JOIN SC B ON A.SNO=B.SNO group by A.DEPART,A.SEX)
GROUP BY A.DEPART, A.SEX;
2
SELECT A.DEPART, A.SEX, SUM(IIF(SEX='男',1,0)) AS 男,SUM(IIF(SEX='女',1,0)) AS 女
FROM [SELECT A.DEPART,A.SEX
FROM S a INNER JOIN SC B ON A.SNO=B.SNO group by A.DEPART,A.SEX]. AS [%$##@_Alias]
GROUP BY A.DEPART, A.SEX;
1
SELECT A.SNO, A.SNAME, COUNT(*)
FROM S AS A INNER JOIN SC AS B ON A.SNO=B.SNO
WHERE B.GRAGE <60 or isnull(B.GRAGE)
GROUP BY A.SNO, A.SNAME;