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
from order_items
group by 1
order by 2 desc;
There seems to be a problem with this course or this activity in particular. Whenever I run the code in Explorer or Chrome, it seems to enter an infinite loop and never gives an answer or an error message. Anybody else get this problem?