| | 1 | = Advanced Reports (SQL, stored procedures and relational algebra) |
| | 2 | |
| | 3 | - [wiki:AdvancedReport1 Orders ordered by order total from highest to lowest] |
| | 4 | - [wiki:AdvancedReport2 List of most popular products with total number of sales] |
| | 5 | - [wiki:AdvancedReport3 List of products that are low on stock and high in demand] |
| | 6 | - [wiki:AdvancedReport4 List of each store's total sales] |
| | 7 | - [wiki:AdvancedReport5 List of each store's monthly sales] |
| | 8 | - [wiki:AdvancedReport6 Each product's monthly sales] |
| | 9 | - [wiki:AdvancedReport7 Stores ordered by total revenue in the last calendar year from highest to lowest] |
| | 10 | - [wiki:AdvancedReport8 List of products who have not been ordered] |
| | 11 | - [wiki:AdvancedReport9 Products ordered by number of orders from highest to lowest] |
| | 12 | - [wiki:AdvancedReport25 Stores ordered by highest approximate product review] |
| | 13 | - [wiki:AdvancedReport10 Store with highest revenue growth in the last calendar year] |
| | 14 | - [wiki:AdvancedReport11 Clients ordered by number of order's] |
| | 15 | - [wiki:AdvancedReport12 Approximate number of orders per client] |
| | 16 | - [wiki:AdvancedReport13 List of clients who haven't made an order] |
| | 17 | - [wiki:AdvancedReport14 Requests ordered by their client satisfaction grade] |
| | 18 | - [wiki:AdvancedReport15 Each store's number of request, including how many have been solved, and how many are still in progress] |
| | 19 | - [wiki:AdvancedReport16 Top 10 employees who have answered the most amount of request in the last month] |
| | 20 | - [wiki:AdvancedReport17 Employees ordered by total hours worked and total pay] |
| | 21 | - [wiki:AdvancedReport18 Each store's average pay] |
| | 22 | - [wiki:AdvancedReport19 Number of product changes each employee has made in the last month] |
| | 23 | - [wiki:AdvancedReport20 Stores ordered by monthly profit including monthly revenue growth] |
| | 24 | - [wiki:AdvancedReport21 List of reports which haven't been approved] |
| | 25 | |
| | 26 | |
| | 27 | == |
