Hi, I've been stuck on this exercise for over an hour and I can't seem to find any help. Usually, after several attempts it will give me the solution but not in this case. Anyone spot what I did wrong?
Error: near line 1: near "select": syntax error
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 'tikka-masala' THEN 'dinner' WHEN 'chicken-parm' THEN 'dinner' ELSE 'other' END AS category, round(1.0 * sum(amount_paid) / sum(select amount_paid from order_items) * 100, 2) AS pct FROM order_items GROUP BY 1 ORDER BY 2 desc;