求select多个表语句

Question

A表 aid ,name
B表 bid ,aid,bname
c表 cid,bid
我想搜出C表中按bid分类的数量，A表的name,B表的bname按照刚才的数量降序排列

Answer 1

select
   a.name,b.bname,count(c.bid) 
from
   a,b,c
where
   a.aid=b.aid
and
   b.bid=c.bid
group by
   a.name.b.bname
order by
   3 desc

Answer 2

select a.name,b.bname,d.bid,d.amount
from a,b,(
select bid,count(cid) amount
from c
group by bid) d
where a.aid=b.aid
and b.bid=c.did
and c.bid=d.bid
order by a.name,b.bname desc