Issues when running code on Grouping with Case Statements


I am having trouble with the second exercise on 1.9, Grouping With Case Statements. I edited the provided code to add ‘sum(amount_paid)’ after the second select statement to get the percentage sales for each category. However, when I hit ‘run’ the editor just runs forever, or until my browser freezes. What is the problem with my code that’s creating this issue?

<Below this line, add a link to the EXACT exercise that you are stuck at.>

Here’s the link to the exercises: 1.9 I am stuck on the second exercise.

<Below this line, in what way does your code behave incorrectly? Include ALL error messages.>
Here’s the code just runs until my browser freezes.
<In this course, it often helps to include a screenshot of your whole web browser – that lets everyone see what you see. If you wish to include a screenshot, add it below this line.>

<If you wish to copy/paste in your code, you can use this next section. This will allow others to copy/paste your code for testing – something that they won’t be able to do with just a screenshot.>


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) /
(select sum(amount_paid) from order_items) * 100, 2) as pct
from order_items
group by 1
order by 2 desc;

<do not remove the three backticks above>

Not sure we need to select all.

  CASE name

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