A virtual data analyst job for students and freshers in India. Practise the work, not just the syntax.

Product

Scenario library
Pricing
How it works

For you

Students
Trainers & colleges
FAQ

Company

Contact
Institutions

© DataDesk. All companies, people and datasets are fictional.

Made for learners in India 🇮🇳

SQL interview questions — practice questions · DataDesk

Practice
Live projects
Guided projects
For colleges
Pricing

Log in Start free

SQL

SQL interview questions

Classic interview patterns from every topic.

Your progress0 / 57

Start the first question

1Backup before a risky change InterviewAdvanced
2Valid Indian mobile numbers InterviewAdvanced
3Library design InterviewAdvanced
4Keep the latest record InterviewAdvanced
5Monthly summary table InterviewAdvanced
6View of department KPIs InterviewAdvanced
7Long-serving and well paid InterviewAdvanced
8Second highest salary InterviewAdvanced
9Top 3 with ties InterviewAdvanced
10Revenue by category InterviewAdvanced
11Average order value InterviewAdvanced
12Above the company average InterviewAdvanced
13Duplicate emails, case-insensitive InterviewAdvanced
14Departments without staff InterviewBasic
15Products never ordered InterviewBasic
16Sold below list price InterviewAdvanced
17Customers who bought both InterviewAdvanced
18Employee and manager InterviewBasic
19Earns more than the manager InterviewIntermediate
20Skip-level manager InterviewAdvanced
21Consecutive-day logins InterviewAdvanced
22Above the average InterviewBasic
23Above their department average InterviewIntermediate
24Nth highest salary InterviewAdvanced
25Org chart levels InterviewAdvanced
26Fill missing months InterviewAdvanced
27Repeat purchase rate InterviewAdvanced
28Cohort retention InterviewAdvanced
29Pivot with CASE InterviewIntermediate
30Fee status report InterviewAdvanced
31Flag suspicious transactions InterviewAdvanced
32NOT IN trap InterviewIntermediate
33Fill gaps with the previous value InterviewAdvanced
34Clean phone numbers InterviewAdvanced
35Most common first letter InterviewAdvanced
36Month-over-month growth InterviewAdvanced
37Fiscal year InterviewAdvanced
38Login streaks InterviewAdvanced
39Top earner per department InterviewIntermediate
40Top 2 per department InterviewIntermediate
41Remove duplicates with ROW_NUMBER InterviewIntermediate
42Nth highest with DENSE_RANK InterviewAdvanced
43Month-over-month change InterviewIntermediate
443-month moving average InterviewIntermediate
45Account balance InterviewIntermediate
46Growth streaks InterviewAdvanced
47Cumulative share (Pareto) InterviewAdvanced
48Sessions from logins InterviewAdvanced
49Symmetric difference InterviewAdvanced
50Compare two table versions InterviewAdvanced
51Best customers report InterviewBasic
52Month-wise new vs returning customers InterviewIntermediate
53Frequently bought together InterviewIntermediate
54Customer lifetime summary InterviewAdvanced
55Churned customers InterviewAdvanced
56Second purchase conversion InterviewAdvanced
57Executive dashboard row InterviewAdvanced

By level

Basic0 / 5
Intermediate0 / 12
Advanced0 / 40

SQL topics

Interview questions0/57
CREATE TABLE & data types0/40
Constraints0/40
INSERT, UPDATE & DELETE0/40
ALTER, DROP & views0/40
SELECT & WHERE0/40
ORDER BY, LIMIT & DISTINCT0/40
Aggregates & GROUP BY0/40
HAVING0/40
Joins0/40
Self & cross joins0/40
Subqueries0/40
CTEs (WITH)0/40
CASE WHEN0/40
NULL handling0/40
String functions0/40
Date functions0/40
Window functions: ranking0/40
Window functions: LAG, LEAD & running totals0/40
UNION, INTERSECT & EXCEPT0/40
Mixed & interview problems0/40