宣传 网站建设方案百度统计代码安装位置

好友申请二：谁有最多的好友

实现

with tmp as (selectrequester_id idfrom RequestAcceptedunion allselectaccepter_id idfrom RequestAccepted
)selectid,count(*) num
from tmp
group by id
order by num desc
limit 1;