Changes between Version 2 and Version 3 of SQL
- Timestamp:
- 01/21/25 22:41:55 (5 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
SQL
v2 v3 1 == =Advanced SQL Queries and Reports for Invoices1 == Advanced SQL Queries and Reports for Invoices 2 2 3 == 1. Report: Total Revenue Generated by Each Company in the Last Year3 === 1. Report: Total Revenue Generated by Each Company in the Last Year 4 4 5 5 {{{ … … 19 19 }}} 20 20 21 == 2. Report: Invoices Issued to Each Client and Their Total Amount21 === 2. Report: Invoices Issued to Each Client and Their Total Amount 22 22 {{{ 23 23 SELECT … … 35 35 }}} 36 36 37 == 3. Report: List of Overdue Invoices37 === 3. Report: List of Overdue Invoices 38 38 {{{ 39 39 SELECT … … 54 54 }}} 55 55 56 == 4. Report: Clients with the Highest Invoice Payments56 === 4. Report: Clients with the Highest Invoice Payments 57 57 {{{ 58 58 SELECT … … 72 72 }}} 73 73 74 == 5. Report: Outstanding Invoices by Each Client74 === 5. Report: Outstanding Invoices by Each Client 75 75 {{{ 76 76 SELECT … … 90 90 }}} 91 91 92 == 6. Report: Monthly Invoice Revenue92 === 6. Report: Monthly Invoice Revenue 93 93 {{{ 94 94 SELECT … … 117 117 }}} 118 118 119 == 8. Report: Invoices with the Most Line Items119 === 8. Report: Invoices with the Most Line Items 120 120 {{{ 121 121 SELECT … … 144 144 }}} 145 145 146 == 10. Report: Invoices with Discounts Applied146 === 10. Report: Invoices with Discounts Applied 147 147 {{{ 148 148 SELECT
