ASSIGNMENT
Show the SQL statement of the following Queries.
- For each category of Employee, count the number of employees in that category, and the average salary of that category.
- Find the average number of orders placed by Customer.
- Find all the customers who purchased the Popular-Product.
- Find the store that has most different products in stock.
- Find the floor staff who has taken charge of all the floors in the past 1 week.
- For each product, list all the stores selling it, and the price of the product at the stores.
- Find the floor that have the most number of stores located.
- List the schedule of the Gold-Store.
- Find the store that produces the most amount of sale in the past 1 week.
- Find the employee who supervises the most number of floor staffs
- https://www.studypool.com/questions/download?id=2830872&path=uploads/questions/1321933/20230501201050project_part2.drawio.pdf&fileDownloadName=attachment_1
