9.1 Category column shows up in the sidebar


#1

I have the following:

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 'sandwhich'
when 'grilled-
cheese' then
'sandwhich'
when 'tikka-masala'
then 'dinner'
when 'chicken-parm'
then 'dinner'
else 'other'
end as category
from order_items
order by id
limit 100;

I still get an error message telling me to "Add a category column" even though the category column shows up in the sidebar.


Add a category column
#2

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