Your question is Running Total 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.
The Tata Consultancy Services North America sales team tracks TCS BaNCS implementation revenue across client accounts. Write a PostgreSQL query that reports monthly North American sales and the cumulative sales total through each month.
North America region.YYYY-MM, monthly sales, and the running total, ordered from earliest to latest month.| Column | Type | Description |
|---|---|---|
| account_idPK | INTEGER | Unique client account identifier |
| account_name | VARCHAR(100) | Client account name |
| region | VARCHAR(50) | Client sales region |
| Column | Type | Description |
|---|---|---|
| transaction_idPK | INTEGER | Unique sales transaction identifier |
| account_id | INTEGER | References tcs_client_accounts.account_id |
| sale_date | DATE | Date of the sale |
| amount | NUMERIC(12,2) | Sales amount in USD |