这显示为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 被接纳的女性A89 被拒绝的女性A 19 被拒绝的女性B 8 被接纳的女性B 17 被拒绝的男性B 207 获接纳男性B 353
发布于 2014-02-21 16:27:29
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发布于 2014-02-21 16:01:19
如果我正确地理解了您的需求,这应该可以做到:
SELECT
Gender,
SUM(Freq) AS TotalApp,
SUM(CASE WHEN Admit = 'Rejected' THEN 0 else Freq END) AS AdmRate
FROM ucbadmissions
GROUP BY Gender这将返回性别加上申请总数加上每个性别的成功申请数量。
https://stackoverflow.com/questions/21939019
复制相似问题