Won't let me advance (9.1)


#1

my code is below and I am pretty sure it should work but it gives me an error every time.

What did I misplace?

SELECT *,
CASE name
WHEN ‘kale-smoothie’ THEN ‘smoothie’
WHEN ’ banana-smoothie’ THEN 'smoothie’
WHEN ‘soda’ THEN 'drink’
WHEN ‘orange-juice’ THEN 'drink’
WHEN ‘blt’ THEN 'samdwich’
WHEN ‘grilled-cheese’ THEN 'snadwich’
WHEN ‘tikka-masala’ THEN 'dinner’
WHEN ‘chicken-parm’ THEN 'dinner’
ELSE 'other’
END AS category
FROM order_items
ORDER BY id
limit 100;



Replace this line with your code. 



#2

Have a close look at

snadwich

and

samdwich


#3

Haha holy crap. I got so mad and it was a little tiny mistake.

Thank you so much.


#4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.