I have two tables, USERS and REVIEWS
The reviews table contains reviews of the users, with a link on the ID column. A user can have no reviews, or many reviews, the review is a numerical value from 1-5.
I want to perform a SELECT query on the USER table, that will only return users with reviews, and then ORDER them by the users average review value (highest reviewed users first)
SELECT DISTINCT user.ID
RIGHT OUTER JOIN [Review] ON user.ID = review.modelID
ORDER BY review.ranking DESC