README.md

Table of Content

• Basic Select 20 problems
• Advanced Select 10 problems
• Aggregation 15 problems
• Basic and Advanced Join 15 problems

HackerRank - Basic Select 20 problems Solutions

#	Problem Title	Keywords
01	Revising the Select Query I
02	Revising the Select Query II
03	Select All
04	Select By ID
05	Japanese Cities' Attributes
06	Japanese Cities' Names
07	Weather Observation Station 1
08	Weather Observation Station 3
09	Weather Observation Station 4
10	Weather Observation Station 5
11	Weather Observation Station 6
12	Weather Observation Station 7
13	Weather Observation Station 8
14	Weather Observation Station 9
15	Weather Observation Station 10
16	Weather Observation Station 11
17	Weather Observation Station 12
18	Higher Than 75 Marks
19	Employee Names
20	Employee Salaries

HackerRank - Advanced Select 10 problems Solutions

#	Problem Title	Keywords
01	Type of Triangle
02	The PADS
03	Occupations
04	Binary Tree Nodes
05	New Companies
06	Draw The Triangle 1
07	Draw The Triangle 2
08	Print Prime Numbers

HackerRank - Aggregation 15 problems Solutions

#	Problem Title	Keywords
01	Revising Aggregations - The Count Function
02	Revising Aggregations - The Sum Function
03	Revising Aggregations - Averages
04	Average Population
05	Japan Population
06	Population Density Difference
07	The Blunder
08	Top Earners
09	Weather Observation Station 2
10	Weather Observation Station 13
11	Weather Observation Station 14
12	Weather Observation Station 15
13	Weather Observation Station 16
14	Weather Observation Station 17
15	Weather Observation Station 18
16	Weather Observation Station 19
17	Weather Observation Station 20

HackerRank - Basic and Advanced Join 15 problems Solutions

#	Problem Title	Keywords
01	Population Census
02	African Cities
03	Average Population of Each Continent
04	The Report
05	Top Competitors
06	Ollivander's Inventory
07	Challenges
08	Contest Leaderboard
09	SQL Project Planning
10	Placements
11	Symmetric Pairs
12	Interviews
13	15 Days of Learning SQL