12/4-2 where clause


#1

Hi
Can anybody pls help without where clause syntax working

thanks in advance


select DATE(ordered_at), round(sum(amount_paid), 2)
from orders
join  order_items 
on orders.id = order_items.order_id

where name = 'kale-smoothie'

group by 1
order by 1


#2

solved
missing ; lol


#3

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