Good afternoon everyone
I have been asked to provide the SQL queries to retrieve the following:
- Show the top 10 highest rated holiday spots.
- Show the top 10 most reviewed.
- Show the top 10 most clicked on/visited.
The queries will be related to the ER diagram on top. I have tried to find a solution but i am still new to SQL and it seems that all my solutions are wrong. Please let me know if you have a hint on how to do it as i am really going crazy for this thing. Thanks in advance.