请教一个sql语句的写法

新闻表news id,c_id,tim,topic

评论表 review rid,rsort,re_id

新闻表需要根据 评论数来排序 ，两表的连接条件是 news.id=review.re_id


这sql语句要怎么写呢

---

SQL code:
SELECT * from news AS A
ORDER BY ISNULL((SELECT COUNT(*) from reveiw
WHERE A.id = re_id),0) DESC;

---

给出数据吧！

---

SQL code:
select n.id,n.c_id,n.tim,n.topic,r.rid,r.rsort,r.re_id

from news n inner join review r on n.id=r.re_id order by r.rsort desc

---

SQL code:
select a.* from news a left join review b on a.id=b.re_id order by b.评论数字段

---

SQL code:

select a.* from news a
left join(
select re_id ,num=count(*) from review group by re_id
)b on a.id=b.re_id
order by num desc

---

SQL code:

select news.id,news.c_id,news.topic,R.评论数
from news
left join
(select re_id,count(*) as 评论数
from review
group