这显示为NULL。
SELECT Gender, SUM( DISTINCT Freq ) AS TotalApp,
(
SELECT SUM( Freq )
FROM ucbadmissions
WHERE Admit = 'Rejected'
IN (
SELECT Admit
FROM ucbadmissions
)
) AS AdmRate
FROM ucbadmissions
GROUP BY Gender
这显示为错误。
SELECT Gender, SUM( DISTINCT Freq ) AS TotalApp,
(
SELECT SUM( Freq )
FROM ucbadmissions
WHERE Admit != 'Rejected'
Group By Gender
) AS AdmRate
FROM ucbadmissions
Group By Gender
表的示例。
承认性别部门的频率
承认男性A 512
被拒绝男性A 313被
承认女性A 89
被拒绝女性A 19
被拒绝女性B 8被
承认女性B 17
被拒绝男性B 207被
承认男性B 353
SELECT Gender, SUM(Freq) AS TotalApp,
SUM(CASE WHEN Admit = 'Admitted' THEN Freq ELSE 0 END) / SUM(Freq) AS AdmitRate
FROM ucbAdmissions
GROUP BY Gender
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句