Write a query to find employees in the same department as 'John'.
SQLmedium
2
Write a query to find minimum age.
SQLeasy
3
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.
SQLmedium
4
Write a query to find the first number repeating consecutively three times in a sequence.
SQLeasy
5
Write a query to find the median salary of employees in a table.
SQLeasy
6
Write a query to find the top 5 most-sold Adidas products in the last month.
SQLmedium
7
Write a query to find the top three customers by total revenue within each region.
SQLmedium
8
Write a query to find the total number of rides per driver in the last 30 days.
SQLmedium
+20 More Questions with Expert Answers
Get the complete 1,800+ question library with detailed, expert-level answers covering SQL, Spark, System Design, Python, Cloud, and Behavioral topics.