In the course How to Analyze Business Metric with SQL:
Here is the question:
We’ll build our own categories using a case statement. Complete the query below with a case condition of name that lists out each product, and decides its group.
select
/**/
when ‘kale-smoothie’ then ‘smoothie’
when ‘banana-smoothie’ then ‘smoothie’
when ‘orange-juice’ then ‘drink’
when ‘soda’ then ‘drink’
when ‘blt’ then ‘sandwich’
when ‘grilled-cheese’ then ‘sandwich’
when ‘tikka-masala’ then ‘dinner’
when ‘chicken-parm’ then ‘dinner’
else ‘other’
end as category
from order_items
order by id
limit 100;
Here is my code the gets an error “Add a case name statement”
SELECT *,
CASE name
WHEN ‘kale-smoothie’ THEN ‘smoothie’
WHEN ‘banana-smoothie’ THEN ‘smoothie’
WHEN ‘orange-juice’ THEN ‘drink’
WHEN ‘soda’ THEN ‘drink’
WHEN ‘blt’ THEN ‘sandwich’
WHEN ‘grilled-cheese’ THEN ‘sandwich’
WHEN ‘tikki-nasala’ THEN ‘dinner’
WHEN ‘chicken-parm’ THEN ‘dinner’
ELSE ‘other’
END AS ‘category’
FROM order_items
ORDER BY id
LIMIT 100;
Any tips? The solution given on the page is completely useless and is the solution from a previous worksheet…