Question: SQL SELECT id , CASE WHEN rating 9 . 2 THEN 'Exceptional' WHEN rating 8 . 8 THEN 'Excellent' WHEN rating 8 . 2 THEN
SQL
SELECT id CASE
WHEN rating THEN 'Exceptional'
WHEN rating THEN 'Excellent'
WHEN rating THEN 'Good'
ELSE 'Average or Lower'
END
AS category FROM movies WHERE category LIKE Ex;
Enter the IDs in ascending order, separated by commas, of the rows that will be returned from this query.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
