Find the floor staff who has taken charge of all the floors in the past 1 week.
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. … Read more