SQL: Revenue Per Customer and Change | Dataford Interview Questions

Given table column names, write SQL to calculate the revenue per customer for July, and then calculate the change from June to July.

Asked in the Round 1 Video Interview stage.

Output

One row per customer with July revenue and the June to July change.
Include the customer identifier, July revenue, June revenue, and revenue change.
Return only customers with July activity, ordered by customer identifier.

orders

Your question is SQL: Revenue Per Customer and Change. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Given table column names, write SQL to calculate the revenue per customer for July, and then calculate the change from June to July.

Asked in the Round 1 Video Interview stage.

One row per customer with July revenue and the June to July change.
Include the customer identifier, July revenue, June revenue, and revenue change.
Return only customers with July activity, ordered by customer identifier.

orders

Your question is SQL: Revenue Per Customer and Change. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.