How do the three financial statements link together?
For this SQL exercise, summarize the reported amounts for each statement in the requested reporting period. Return one total for each statement and exclude records from other periods.
2024-12-31statement_name, statement_totalstatement_name| Column | Type | Description |
|---|---|---|
| line_idPK | INT | Unique identifier for the statement line |
| reporting_period | DATE | Reporting period end date |
| statement_name | VARCHAR(50) | Name of the financial statement |
| line_item | VARCHAR(100) | Reported statement line item |
| amount | DECIMAL(14,2) | Reported amount for the line item |