#join

Write a SQL query to rank shows by daily viewership across different regions

Write a query to calculate the total revenue generated by each product category.

Write a query to find employees in the same department as 'John'.

Write a query to find the 5th highest salary in an employee table and calculate the number of employees whose salary is greater than that of their manager.

Write a query to find the top 5 most-sold Adidas products in the last month.

Write a query to get the names of all employees who are managers with five or more direct reports.

Write a query to identify duplicate customer entries based on email and phone number.

Write a self join query to get the manager's name for each employee.