I have a db table that holds details about phones (PhoneID, Name). In another table, I have a db table that will hold customer reviews about each of these phones. (PhoneID, Rating, Review). THe Review db table will contain multiple reviews for the same phone.
What im looking to do is return all phones, ordered by the Rating. (i.e. the average rating for each phone will need to be found first, before I can order by this rating)
Is there any way of achiving this by using only 1 db access?