Fill monthly_revenue with one row per month of 2024 that had delivered orders: the first day of the month, the number of delivered orders, and their revenue (quantity × unit_price).
Tables
customers
customer_idinteger
namevarchar
cityvarchar
statevarchar
signup_datedate
emailvarchar
phonevarchar
referred_byinteger
monthly_revenue
monthdate
ordersinteger
revenueinteger
order_items
order_idinteger
product_idinteger
quantityinteger
unit_priceinteger
orders
order_idinteger
customer_idinteger
order_datedate
statusvarchar
payment_methodvarchar
products
product_idinteger
product_namevarchar
categoryvarchar
priceinteger
stockinteger
Hints(0/2)
Solution
Unlocks after you solve it or after 3 submissions
SQL (DuckDB)
Ctrl + Enter to runLog in to save progress and earn XP