先上两副图
这里有两张表:score表和year_as表,要求统计出score表按年份分组的个数,且查询出来的内容需要包括year_as表中的year_as字段.
使用正常连表并分组统计count得出的SQL和对应结果如下:
SELECT
b.`year`,
b.year_as,
COUNT(a.`id`) AS num
FROM
`score` AS a
LEFT JOIN `year_as` AS b
ON
a.`year` = b.`year`
GROUP BY
a.`year`
ORDER BY
num
DESC