Question

We sell music  to our members. Employees recommend titles by rating them from1 to 5 with 1 being not very good to 5 being very good

Write the SQL code (with each clause on its own line to "Show the product titles whose average rating is above the average rating for all products"

Answer 1

The query should be:

SELECT Title

FROM Products (Table Name)

WHERE Rating > (SELECT AVG(RATING) FROM Products);

Explanation:

Select Clause, will display the columns mentioned, that is Title.

From Clause, will mention the Table Name, Products.

Where Clause, mentions the condition that Rating should be greater than the average rating of the products, which is found by another subquery.

PLEASE UPVOTE IF YOU FOUND THIS HELPFUL!