Your question is Month-over-Month Revenue Growth in SQL. Start with the requirements and the two tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Boston Consulting Group's Financial Planning and Analysis team wants to monitor revenue trends for the Strategy practice area. Write a PostgreSQL query that calculates monthly revenue and month-over-month growth.
Strategy practice area and calendar year 2024.NULL for the first month or when the previous month's revenue is zero.| Column | Type | Description |
|---|---|---|
| practice_area_idPK | INT | Unique practice area identifier |
| practice_name | VARCHAR(100) | BCG consulting practice name |
| Column | Type | Description |
|---|---|---|
| revenue_idPK | INT | Unique revenue record identifier |
| practice_area_id | INT | Referenced practice area |
| engagement_code | VARCHAR(20) | BCG engagement reference code |
| revenue_date | DATE | Date revenue was recognized |
| revenue_amount | NUMERIC(12,2) | Recognized revenue amount |