Giter VIP home page Giter VIP logo

hackerrank-sql-challenges-solutions's Introduction

HackerRank-SQL-Challenges-Solutions

Description

My solutions of all the SQL challenges for all easy, medium and hard challenges on HackerRank.

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 Revising Aggregations - The Count Function SQL
2 Revising Aggregations - The Sum Function SQL
3 Revising Aggregations - Averages SQL
4 Average Population SQL
5 Japan Population SQL
6 Population Density Difference SQL
7 The Blunder SQL
8 Top Earners SQL
9 Weather Observation Station 2 SQL
10 Weather Observation Station 13 SQL
11 Weather Observation Station 14 SQL
12 Weather Observation Station 15 SQL
13 Weather Observation Station 16 SQL
14 Weather Observation Station 17 SQL
15 Weather Observation Station 18 SQL
16 Weather Observation Station 19 SQL
17 Weather Observation Station 20 SQL

Basic Join

Number Challenges Solutions
1 Population Census SQL
2 African Cities SQL
3 Average Population of Each Continent SQL
4 The Report SQL
5 Top Competitors SQL
6 Ollivander's Inventory SQL
7 Challenges SQL
8 Contest Leaderboard SQL

Advanced Join

Number Challenges Solutions
1 SQL Project Planning SQL
2 Placements SQL
3 Symmetric Pairs SQL
4 Interviews SQL
5 15 Days of Learning SQL SQL

Alternative Queries

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

hackerrank-sql-challenges-solutions's People

Contributors

sandramoses avatar

Watchers

avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.