SQL Challenges

---

📝 Table of Contents

• 📙 Overview
• 🗳️ Domains
  • Basic Select
  • Advanced Select
  • Aggregation
  • Basic Join
  • Alternative Queries
• ✨ Contributors
• 🔒 License

---

📙 Overview

The solutions of SQL challenges for easy, medium and hard challenges on HackerRank executed on MySQL environment compiled with helpful Resources & references related to the challenges.

---

✅ Domains

Basic Select Challenges

Number	Challenges	Solutions
1	Revising the Select Query I	SQL
2	Revising the Select Query II	SQL
3	Select All	SQL
4	Select By ID	SQL
5	Japanese Cities' Attributes	SQL
6	Japanese Cities' Names	SQL
7	Weather Observation Station 1	SQL
8	Weather Observation Station 3	SQL
9	Weather Observation Station 4	SQL
10	Weather Observation Station 5	SQL
11	Weather Observation Station 6	SQL
12	Weather Observation Station 7	SQL
13	Weather Observation Station 8	SQL
14	Weather Observation Station 9	SQL
15	Weather Observation Station 10	SQL
16	Weather Observation Station 11	SQL
17	Weather Observation Station 12	SQL
18	Higher Than 75 Marks	SQL
19	Employee Names	SQL
20	Employee Salaries	SQL

Advanced Select Challenges

Number	Challenges	Solutions
1	Type of Triangle	SQL
2	The PADS	SQL
3	Occupations	SQL
4	Binary Tree Nodes	SQL
5	New Companies	SQL

Aggregation Challenges

Number	Challenges	Solutions
1	Average Population	SQL
2	Japan Population	SQL
3	Population Density Difference	SQL
4	The Blunder	SQL
5	Top Earners	SQL
6	Weather Observation Station 18	SQL
7	Weather Observation Station 19	SQL

Basic Join Challenges

Number	Challenges	Solutions
1	Average Population of Each Continent	SQL
2	The Report	SQL
3	Top Competitors	SQL
4	Ollivander's Inventory	SQL
5	Challenges	SQL

Alternative Queries Challenges

Number	Challenges	Solutions
1	Draw The Triangle 1	SQL
2	Draw The Triangle 2	SQL
3	Print Prime Numbers	SQL

---

👑 Contributors

Eslam Ashraf

---

🔒 License

Note: This software is licensed under MIT License, See License for more information ©EslamAsHhraf.