Issues when running code on Grouping with Case Statements


#1

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?


#2

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


#3

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