SQL Programming Advanced Quiz 3

1. Write a SQL query to count the number of orders placed by each customer in an "Orders" table.

2. Write a SQL query to find employees with the same manager.

3. Write a SQL query to find the total number of unique products sold last month.

4. Write a SQL query to pivot sales data by month for each product.

5. Write a SQL query to retrieve the top 5 highest-paid employees.

6. Write a SQL query to find customers who have not placed any orders.

7. What is a FOREIGN KEY?

8. What is a window function? Write a query to calculate running total of sales.

9. Write a SQL query to delete duplicate rows in a table (in most SQL dialects).

10. Write a SQL query to select all records where "score" is not between 50 and 80.