Skip to interview prep
Apexed

Monthly revenue with month-over-month change

Window functionsMedium

Return month (YYYY-MM), revenue and change (revenue minus the previous month's; NULL for the first month), ordered by month. Round money to 2 decimals.

Tables

  • customers: id, name, email, country
  • orders: id, customer_id, ordered_on (YYYY-MM-DD), amount

Row order is checked. Column names do not have to match, but the number of columns and the values do.

Tab indents · Ctrl/⌘ + Enter runs · Esc then Tab leaves the editor

Run your query. It is checked against the expected result on the same data.

Solution

Queries run only in your browser on a private SQLite database (sql.js from a public CDN). Nothing is sent to Apexed.

Monthly revenue with month-over-month change: SQL interview practice — Apexed