# Write your MySQL query statement below
select ids as id, cnt as num
from
(
select ids, count(*) as cnt
from
(
select requester_id as ids from RequestAccepted
union all
select accepter_id from RequestAccepted
) as tb1
group by ids
) as tb2
order by cnt desc
limit 1;
#Union All:对两个结果集进行并集操作,包括重复行,不进行排序
#sum()用于求和,count()用于行数的统计。
#sum()列值为空时不计算,count()为空时认为没有这一行。
#sum()为空时返回结果为null
union all的效果: