How can I retrive the top 3 rated events MySQL
I have sporting events that users can rate. All data is stored in a Mysql
database.
Ratings_table:
rating_id PK
organisation float
value_for_money float
fun_factor float
facilities float
event_id int
user_id int
Event_table:
event_id PK
event_name varchar
Is there a way I can use Mysql query to join the tables and order them so
that the 3 highest rated events are retrieved?
No comments:
Post a Comment