1783 大满贯数量

题目描述：

请写出查询语句，查询出每一个球员赢得大满贯比赛的次数。结果不包含没有赢得比赛的球员的ID 。
结果集无顺序要求。
查询结果的格式，如下所示：

方法1:
主要思路：解题汇总链接

select p.player_id as player_id, p.player_name as player_name, count(p.player_name) as grand_slams_count 
from Players as p join (
    select year,Wimbledon as player_id from Championships
    union all select year, Fr_open as player_id from Championships
    union all select year, US_open as player_id from Championships
    union all select year, Au_open as player_id from Championships
) as t on p.player_id = t.player_id 
group by p.player_id