Sort products by number of reviews
I have a mysql database with 

 - table 'product' containing columns 'product_id', 'name', 'price'
 - table 'review' containing columns 'review_id', 'product_id', 'review_content'

I want to retrieve results for 'product_id' = 123, but sort if by number of reviews. I am able to find the number of reviews for a particular product using COUNT('review_id'), but how do I sort the results by number of reviews?

 



Sort products by number of reviews
===

I have a mysql database with 

 - table 'product' containing columns 'product_id', 'name', 'price'
 - table 'review' containing columns 'review_id', 'product_id', 'review_content'

I want to retrieve results for 'product_id' = 123, but sort if by number of reviews. I am able to find the number of reviews for a particular product using COUNT('review_id'), but how do I sort the results by number of reviews?

 


