mysql 如何按照数量进行排序

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

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

---