例如: 表shop 有 shop_id字段。 表goods对应的 shop_id 字段 。shop一对多goods
所以现在要按照goods表中对应shop的个数 来对shop从多到少进行排列。
请用2句查询语句来实现 。一句至多有一个select
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