mysql 一张表根据另外一张表统计的个数来排序

select t1.shop_id,count(1)

from shop t1 left join goods t2 on t1.shop_id=t2.shop_id

group by t1.shop_id

order by count(1) desc

select commentId, count(status=1) as times from t_like group by commentId order by commentId desc limit 6

---