按语法错误分组

debugcn 发表于 Dev

用户名

这显示为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] 删除。