SQL Statement

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