#join

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

Write a query to generate the specified output using advanced SQL skills with joins, aggregations, and window functions.

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.

Write optimized SQL queries involving window functions, CTEs, and joins.

Write queries combining Joins and Group By operations.

You need to design a Kafka topic for a logging service. How would you decide the number of partitions and the key for partitioning to balance throughput and ordering requirements?