HackerRank SQL Solutions

Overview

These are my solutions to HackerRank's challenges in the SQL Preparation Domain using MySQL.

Subdomains

Advanced Join

Status	HackerRank Description	Solution
✅	SQL Project Planning	MySQL
✅	Placements	MySQL
✅	Symmetric Pairs	MySQL
✅	Interviews	MySQL
✅	15 Days of Learning SQL	MySQL

Advanced Select

Status	HackerRank Description	Solution
✅	Type of Triangle	MySQL
✅	The PADs	MySQL
✅	Occupations	MySQL
✅	Binary Tree Nodes	MySQL
✅	Binary Tree Nodes	MySQL

Aggregations

Status	HackerRank Description	Solution
✅	Revising Aggregations - The Count Function	MySQL
✅	Revising Aggregations - The Sum Function	MySQL
✅	Revising Aggregations - Averages	MySQL
✅	Average Population	MySQL
✅	Japan Population	MySQL
✅	Population Density Difference	MySQL
✅	The Blunder	MySQL
✅	Top Earners	MySQL
✅	Weather Observation Station 2	MySQL
✅	Weather Observation Station 13	MySQL
✅	Weather Observation Station 14	MySQL
✅	Weather Observation Station 15	MySQL
✅	Weather Observation Station 16	MySQL
✅	Weather Observation Station 17	MySQL
✅	Weather Observation Station 18	MySQL
✅	Weather Observation Station 19	MySQL
✅	Weather Observation Station 20	MySQL

Alternative Queries

Status	HackerRank Description	Solution
✅	Draw The Triangle 1	MySQL
✅	Draw The Triangle 2	MySQL
✅	Print Prime Numbers	MySQL

Basic Join

Status	HackerRank Description	Solution
✅	Population Census	MySQL
✅	African Cities	MySQL
✅	Average Population of Each Continent	MySQL
✅	The Report	MySQL
✅	Top Competitors	MySQL
✅	Challenges	MySQL
✅	Contest Leaderboard	MySQL