请写出sql计算每年不同用户发布的笔记数量()
select year,userid,sum(num) as num from temp2 group by 1,2
select year,userid,count(num) as num from temp2 group by 1,2
select year,userid,count(num) as num from temp2
select userid,count(num) as num from temp2 group by 1