DataEngPrep.tech
QuestionsBlogStore
Get PDF Bundle

Interview Questions

Real questions from top companies in SQL · medium

700+ Easy450+ Medium650+ Hard
All CategoriesBehavioralSpark/Big DataSQLPython/CodingSystem Design/ArchitectureCloud/ToolsGeneral/Othereasymediumhard
1

Write a SQL query to find the second highest salary in each department.

SQLmedium
2

Write a SQL query to find the top 3 selling products per region in the last month.

SQLmedium
3

Write a SQL query to find the top 5 most ordered dishes in the last 30 days.

SQLmedium
4

Write a SQL query to find the top 5 products by sales per region.

SQLmedium
5

Write a SQL query to find users to recommend specific artists

SQLmedium
6

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

SQLmedium
7

Write a SQL query to remove duplicates from a table.

SQLmedium
8

Write a query that ranks users by their total order amount within each region.

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.

Get PDF Bundle — from $21Try Free Sample
Previous1...11121314Next