mysql - 如何对计数查询求和

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;

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

标签： mysqlsqlmysql-workbench

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