SQL Subdomain Challenge Score Difficulty Solution Basic Select Revising the Select Query I 10 Easy Solution.sql Basic Select Revising the Select Query II 10 Easy Solution.sql Basic Select Select All 10 Easy Solution.sql Basic Select Select By ID 10 Easy Solution.sql Basic Select Japanese Cities' Attributes 10 Easy Solution.sql Basic Select Japanese Cities' Names 10 Easy Solution.sql Basic Select Weather Observation Station 1 15 Easy Solution.sql Basic Select Weather Observation Station 3 10 Easy Solution.sql Basic Select Weather Observation Station 4 10 Easy Solution.sql Basic Select Weather Observation Station 5 30 Easy Solution.sql Basic Select Weather Observation Station 6 10 Easy Solution.sql Basic Select Weather Observation Station 7 10 Easy Solution.sql Basic Select Weather Observation Station 8 15 Easy Solution.sql Basic Select Weather Observation Station 9 10 Easy Solution.sql Basic Select Weather Observation Station 10 10 Easy Solution.sql Basic Select Weather Observation Station 11 15 Easy Solution.sql Basic Select Weather Observation Station 12 15 Easy Solution.sql Basic Select Higher Than 75 Marks 15 Easy Solution.sql Basic Select Employee Names 10 Easy Solution.sql Basic Select Employee Salaries 10 Easy Solution.sql Advanced Select The PADS 30 Medium Solution.sql Advanced Select Type of Triangle 20 Easy Solution.sql Advanced Select Occupations 30 Medium Solution.sql Advanced Select Binary Tree Nodes 30 Medium Solution.sql Advanced Select New Companies 30 Medium Solution.sql Aggregation Revising Aggregations - The Count Function 10 Easy Solution.sql Aggregation Revising Aggregations - The Sum Function 10 Easy Solution.sql Aggregation Revising Aggregations - Averages 10 Easy Solution.sql Aggregation Average Population 10 Easy Solution.sql Aggregation Japan Population 10 Easy Solution.sql Aggregation Population Density Difference 10 Easy Solution.sql Aggregation The Blunder 15 Easy Solution.sql Aggregation Top Earners 20 Easy Solution.sql Aggregation Weather Observation Station 2 15 Easy Solution.sql Aggregation Weather Observation Station 13 10 Easy Solution.sql Aggregation Weather Observation Station 14 10 Easy Solution.sql Aggregation Weather Observation Station 15 15 Easy Solution.sql Aggregation Weather Observation Station 16 10 Easy Solution.sql Aggregation Weather Observation Station 17 15 Easy Solution.sql Aggregation Weather Observation Station 18 25 Medium Solution.sql Aggregation Weather Observation Station 19 30 Medium Solution.sql Aggregation Weather Observation Station 20 40 Medium Solution.sql Basic Join Asian Population 10 Easy Solution.sql Basic Join African Cities 10 Easy Solution.sql Basic Join Average Population of Each Continent 10 Easy Solution.sql Basic Join The Report 20 Medium Solution.sql Basic Join Top Competitors 30 Medium Solution.sql Basic Join Ollivander's Inventory 30 Medium Solution.sql Basic Join Challenges 30 Medium Solution.sql Basic Join Contest Leaderboard 30 Medium Solution.sql Advanced Join Projects 40 Medium Solution.sql Advanced Join Placements 40 Medium Solution.sql Advanced Join Symmetric Pairs 40 Medium Solution.sql Advanced Join Interviews 50 Hard Solution.sql Advanced Join 15 Days of Learning SQL 50 Hard Solution.sql Alternative Queries Draw The Triangle 1 25 Easy Solution.sql Alternative Queries Draw The Triangle 2 25 Easy Solution.sql Alternative Queries Print Prime Numbers 40 Medium Solution.sql