HackerRank's SQL Challenge!

Solutions for HackerRank's Sql Challenge!

---

Table Of Contents

-Basic Select

-Advanced Select

-Aggregation

-Basic Join

-Advanced Join

-Alternative Queries

---

Basic Select

-Employee Names

-Employee Salaries

-Higher Than 75 Marks

-Japanese Cities Attributes

-Japanese Cities Names

-Revising The Select Query I

-Revising The Select Query II

-Select All

-Select By ID

-Weather Observation Station 1

-Weather Observation Station 3

-Weather Observation Station 4

-Weather Observation Station 5

-Weather Observation Station 6

-Weather Observation Station 7

-Weather Observation Station 8

-Weather Observation Station 9

-Weather Observation Station 10

---

Advanced Select

-Type Of Triangle

-The PADS

-Occupations

-New Companies

-Binary Tree Nodes

---

Aggregation

-Average Population

-Japan Population

-Population Density Difference

-Revising Aggregations - Averages

-Revising Aggregations - The Count Function

-Revising Aggregations - The Sum Function

-The Blunder

-Top Earners

-Weather Observation Station 2

-Weather Observation Station 13

-Weather Observation Station 14

-Weather Observation Station 15

-Weather Observation Station 16

-Weather Observation Station 17

-Weather Observation Station 18

-Weather Observation Station 19

-Weather Observation Station 20

---

Basic Join

-African Cities

-Asian Population

-Average Population of Each Continent

-Challenges

-Contest Leaderboard

-Ollivander's Inventory

-The Report

-Top Competitors

---

Advanced Join

-15 Days Of Learning SQL

-Interviews

-Placements

-SQL Project Planning

-Symmetric Pairs

---

Alternative Queries

-Print Prime Numbers

-Draw The Triangle 1

-Draw The Triangle 2

---

Author Info

SBM

-HackerRank

-Linkedln

---