For each product, list all the stores selling it, and the price of the product at the stores.

Computer Science

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