= Complex DB Reports == 1. Top Selling Products and Restock Plan {{{#!div style="text-align: justify; width: 100%;" This report is meant to look at the best-selling items over **** to figure out exactly when they will sell out and how products should be repurchased. By calculating how many copies of a specific vinyl, CD, or cassette are sold every day and comparing that speed to what is left in stock, the query will find items that will run out of stock in ****. It then automatically calculates the perfect order amount to keep the store supplied for the next **** without overspending, ensuring top money-makers are never missing from the shelves. }}} ==== SQL ==== Relational Algebra == 2. Slow Moving Products {{{#!div style="text-align: justify; width: 100%;" This report is meant to look at items that are completely stuck in inventory. The query scans the database to find products that have either never been bought or have had zero sales for more than ****, while also checking if customers are still adding them to their wishlists or ignoring them completely. It multiplies the current unsold stock by the item's original price to show managers exactly how much cash is frozen in dead inventory, making it easy to see which releases need discounts. }}} ==== SQL ==== Relational Algebra == 3. Impact of Admin Discounts on Sales Numbers ==== SQL ==== Relational Algebra == 4. Customer Habits and Points Spending ==== SQL ==== Relational Algebra