Running revenue with share of year — SQL practice · JobPrax

Practice
Live projects
Guided projects
For colleges
Pricing

Log in Start free

Mixed & interview problems

SQLAdvanced

Running revenue with share of year

PreviousProblem 36 of 40Next

For each month of 2024 with orders: month, revenue, cumulative and pct_of_year (cumulative ÷ year total, 2 decimals), in order.

Tables

customers

customer_idinteger
namevarchar
cityvarchar
statevarchar
signup_datedate
emailvarchar
phonevarchar
referred_byinteger

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)

Each hint gives a little more help. Try on your own first.

Solution

Unlocks after you solve it or after 3 submissions

SQLCtrl + Enter to run

Log in to save progress and earn XP

Run your code to see the output here.