这样的需求能不能用一条SQL实现？

Question

现在想要这样的效果：

name  monthly_count   total_count
a     10              20
b     15              25

name 的 monthly_count 取得方法为：

    select name, count(*) as monthly_count from table_name where updated_at = yyyymm

total_count 的取得条件是：

    select count(*) as total_count from table_name

即不加按月统计。

用一条SQL语句能不能实现呢？

Answer 1

SELECT total_count.name, total_count.cnt, month_count.cnt FROM
(SELECT name, COUNT(*) AS cnt FROM table_name GROUP BY name) AS total_count 
LEFT JOIN
(SELECT name, COUNT(*) AS cnt FROM table_name WHERE updated_at = yyyymm GROUP BY name) AS month_count
ON total_count.name = month_count.name

Answer 2

select name, sum(case when updated_at = yyyymm then 1 else 0) as monthly_count , count(1) as total_count from table_name