Issues when running code on Grouping with Case Statements


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?

Please remember to include a link to the exercise so we can see for ourselves. Thanks.

1 Like

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