JavaScript is required for SkillDojo to work properly. Please enable JavaScript and refresh the page.

Day-over-Day Revenue Change | Algorithm

Hard

Hardperiod-comparisonSQL

Day-over-Day Revenue Change

For the'US' region, return each day's revenue and its change from the previous day's revenue (delta = today - yesterday). The very first day in the series has no previous day — treat its delta as equal to its own revenue (i.e. compare against 0, not NULL).

Expected output

First 3 of 42 rows your query should return. Your column aliases don't need to match.

Tables · Analytics — Daily Metrics

daily_sales

dayTEXTpkregionTEXTpkrevenueREALordersINTEGER

day	region	revenue	orders
2023-01-01	US	550	11
2023-01-02	US	1010	20
2023-01-03	US	1020	20
2023-01-04	US	1030	21
2023-01-05	US	1040	21

signups

dayTEXTpksignup_countINTEGER

0 of 3 hints revealed

Submit an attempt first.