一条sql语句如何查出所有文章和相对应的评论条数

Question

两张表，一张文章吧，一张评论表，如何用一条sql语句查出所有文章和每篇文章对应的评论条数

Answer 1

 select article.* , 
       (select count(id) from reviews where reviews.article_id = article.id) as reviewsCount
from article
order by article.id