| Version 3 (modified by , 7 weeks ago) ( diff ) |
|---|
Advanced Reports (SQL, stored procedures and relational algebra)
- Orders ordered by order total from highest to lowest
- List of most popular products with total number of sales
- List of products that are low on stock and high in demand
- Each product's monthly sales
- Stores ordered by total revenue in the last calendar year from highest to lowest
- List of products who have not been ordered
- Products ordered by number of orders from highest to lowest
- Stores ordered by highest approximate product review
- Store with highest revenue growth in the last calendar year
- Clients ordered by number of order's
- Approximate number of orders per client
- List of clients who haven't made an order
- Requests ordered by their client satisfaction grade
- Each store's number of request, including how many have been solved, and how many are still in progress
- Top 10 employees who have answered the most amount of request in the last month
- Employees ordered by total hours worked and total pay
- Each store's average pay
- Number of product changes each employee has made in the last month
- Stores ordered by monthly profit including monthly revenue growth
- List of reports which haven't been approved
Note:
See TracWiki
for help on using the wiki.
