sno Topic Level Question Source Source Link Link to question
1 Basic Select Easy Invalid Tweets Leetcode Search an element in Arrays | codechef SQL Queries
2 Basic Select Easy Big Countries Hackerrank For Loop | HackerRank SQL Queries
3 Basic Select Easy Recyclable and Low Fat Products LeetCode Plus One | Leetcode SQL Queries
4 Basic Select Easy Query all columns of american cities [Link]
Hackerrank SQL Queries
5 Basic Select Easy Query the name [Link]
Hackerrank SQL Queries
6 Basic Select Easy Japanese Attribute name [Link]
Hackerrank SQL Queries
7 Basic Select Easy Select by ID [Link]
Hackerrank SQL Queries
8 Basic Select Easy Weather Observations [Link]
Hackerrank SQL Queries
9 Basic Select Easy Weather Observations [Link]
Hackerrank SQL Queries
10 Basic Seect Easy List employee names [Link]
Hackerrank SQL Queries
11 Basic Seect Easy Median Hackerrank SQL Queries
Advanced
12 Medium Occupations [Link]
Hackerrank SQL Queries
Select
13 Basic Select Medium Symmetric Pairs [Link]
Hackerrank SQL Queries
14 PL/SQL Easy Floyd's Triangle [Link]
Hackerrank SQL Queries
15 PL/SQL Easy Print Prime [Link]
Hackerrank SQL Queries
16 Basic Select Easy Distinct Companies Codechef [Link] SQL Queries
17 Basic Select Easy Handling Null Values Codechef [Link] SQL Queries
18 Basic Select Easy Player Performance Insights Codechef [Link] SQL Queries
[Link] Topic Level Question Source
Query the names of all African
1 Joins Easy Hackerrank
cities
2 Joins Easy Query the sum of popuations Hackerrank
3 Joins Easy Rising Temperature Leetcode
Managers with atleast five direct
4 Joins Medium Leetcode
reports
Replace employee ID with
5 Joins Easy LeetCode
unique ID
6 Joins Medium Symmetric Pairs Hackerrank
Source Link Link to question
[Link]
Joins
african-cities/problem?isFullScreen=true
[Link]
asian-population/problem? Joins
isFullScreen=true
[Link]
temperature/description/?
Joins
envType=study-plan-v2&envId=top-sql-
50
[Link]
with-at-least-5-direct-reports/
Joins
description/?envType=study-plan-
v2&envId=top-sql-50
[Link]
employee-id-with-the-unique-identifier/
Joins
description/?envType=study-plan-
v2&envId=top-sql-50
[Link]/challenges/symmetric-pairs/problem?isFullScreen=true
Joins
1 Subquery Easy Emplyees whose mgr left companyLeetcode
2 Subquery Medium Exchange Seats Leetcode
3 Subquery Medium Friend Request Leetcode
4 Joins Medium
Managers with atleast five direct reports
Leetcode
5 Joins Easy Replace employee ID with unique IDLeetCode
6 Joins Medium Symmetric Pairs Hackerrank
7 Strings Easy Hackerrank in a String! HackerRank
8 Strings Easy CamelCase HackerRank
9 Strings Easy String Construction HackerRank
10 Strings Easy Beautiful Binary String HackerRank
Subquery
ployees-whose-manager-left-the-company/description/?envType=study-plan-v2&envId=top-sql-50
Subquery
m/problems/exchange-seats/description/?envType=study-plan-v2&envId=top-sql-50
Subquery
end-requests-ii-who-has-the-most-friends/description/?envType=study-plan-v2&envId=top-sql-50
Subquery
managers-with-at-least-5-direct-reports/description/?envType=study-plan-v2&envId=top-sql-50
Subquery
ace-employee-id-with-the-unique-identifier/description/?envType=study-plan-v2&envId=top-sql-50
Single Number | Leetcode Subquery
HackerRank in a String! | Hackerrank Subquery
CamelCase | HackerRank Subquery
String Construction | HackerRank Subquery
Beautiful Binary String | HackerRank Subquery
1 Aggregate Function Easy Not Boring Movies Leetcode
2 Aggregate Function Medium Project Employees Leetcode
3 Aggregate Function Medium Monthly Transactions Leetcode
4 Aggregate Function Medium Game Play Analysis Leetcode
5 Aggregate Function Easy Count no of cities Hackerrank
6 Aggregate Function Easy Sum of Population Hackerrank
7 Aggregate Function Easy Average Populaiton HackerRank
8 Aggregate Function Easy Difference in population HackerRank
9 Aggregate Function Easy Weather Observation HackerRank
10 Aggregate Function Medium 2D Planes HackerRank
[Link]/problems/not-boring-movies/?envType=study-plan-v2&envId=top-sql-50
Aggregate Functions
problems/project-employees-i/description/?envType=study-plan-v2&envId=top-sql-50
Aggregate Functions
oblems/monthly-transactions-i/description/?envType=study-plan-v2&envId=top-sql-50
Aggregate Functions
roblems/game-play-analysis-iv/description/?envType=study-plan-v2&envId=top-sql-50
Aggregate Functions
[Link]/challenges/revising-aggregations-the-count-function/problem?isFullScreen=true
Aggregate Functions
Aggregate Functions
.[Link]/challenges/revising-aggregations-sum/problem?isFullScreen=true
[Link] Functions
[Link] Aggregate Functions
[Link] Aggregate Functions
[Link] Aggregate Functions