question

SQL_learner_89 avatar image
SQL_learner_89 asked

SQL Queries

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.


sqlquery
queries.png (28.4 KiB)
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Jeff Moden avatar image
Jeff Moden answered

To be honest, this looks like homework or interview questions. You might not find many takers without showing that you've at least tried.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.