如何对计数查询求和

Question

我想在使用计数后对3个不同的值求和。这是我得到的3个不同值的查询。

SELECT f.filmid, filmtitel, count(award_type)
FROM film F
INNER JOIN film_award_uitreiking FAU ON F.filmid = FAU.filmid
INNER JOIN Film_award FA ON FA.awardid = FAU.awardid
WHERE fau.filmid = 4317
GROUP BY FA.award_type
ORDER BY count(fau.awardid) DESC;

现在我想把它们总结在一起，有什么建议吗？

Answer 1

select sum(atcount) from
(
SELECT f.filmid, filmtitel, count(award_type) as atcount
FROM film F
INNER JOIN film_award_uitreiking FAU ON F.filmid = FAU.filmid
INNER JOIN Film_award FA ON FA.awardid = FAU.awardid
WHERE fau.filmid = 4317
GROUP BY FA.award_type
) x