• Stars
    star
    645
  • Rank 67,147 (Top 2 %)
  • Language SQL
  • License
    MIT License
  • Created over 6 years ago
  • Updated 7 months ago

Reviews

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

Repository Details

The solutions of all SQL hackerrank challenges using MySQL environment

GitHub GitHub top language GitHub last commit ViewCount




Description

The solutions of all the SQL challenges for all 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 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 Asian Population 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

References

Features & Mentions

This project was featured in laptrinhx. Thank you for the listing!

License

This repository is licensed under MIT License - see License for more details

More Repositories

1

IBM-Data-Science-Professional-Certification

Learning materials, Quizzes & Assignment solutions for the entire IBM data science professional certification. Also included, a few resources that I found helpful.
Jupyter Notebook
251
star
2

Movies-Analytics-in-Spark-and-Scala

Data cleaning, pre-processing, and Analytics on a million movies using Spark and Scala.
Scala
84
star
3

HackerRank-The-Linux-Shell-Challenges-Solutions

Complete Solutions and related tutorials for the Linux Shell - Bash, text processing, Arrays in Bash, Grep Sed Awk Challenges on HackerRank
Shell
76
star
4

Thomas-George-T

Readme for my :octocat: Profile
59
star
5

Social-Media-Analytics-in-R

Taking a look at data of 1.6 million twitter users and drawing useful insights while exploring interesting patterns visualized with concise plots. The techniques used include text mining, sentimental analysis, probability, time series analysis and Hierarchical clustering on text/words using R.
RMarkdown
11
star
6

Prediciting-Hits-on-Spotify

Predicting hit songs on Spotify by classifying 40,000 songs using Machine Learning
Jupyter Notebook
9
star
7

A-Tale-of-Two-Cities

Clustering Neighborhoods of Paris and London using Machine learning. IBM Data Science Capstone
Jupyter Notebook
8
star
8

Forecasting-Healthcare-Costs

Predicting the cost of treatment and insurance using Machine Learning
Jupyter Notebook
7
star
9

AWS-Solutions-Architect-Associate

Materials & Resources aimed at acquiring the AWS Certified Solutions Architect Associate 2020
6
star
10

Kafka-Tweet-Stream

Stream real time Tweets of current affairs like covid-19 using Kafka 2.0.0 high throughput producer & consumer into Elasticsearch using safe, idempotent and compression configurations. Aggregate the data and use it for further analytics.
Java
6
star
11

Ecommerce-Data-MLOps

End-to-End deployment of E-commerce customers segmentation using Clustering Machine learning algorithms in Google Cloud Platform and MLOps Tools
Python
5
star
12

File-Processing-Comparative-Analytics

Wanna know which languages and execution engines are the quickest or the slowest at processing files? Well here's your answer. 📊 Data Analysis & comparison between the time taken ⌚ for computing word counts in various languages and execution engines for files of different sizes.
Jupyter Notebook
5
star
13

Olympic-History-Analytics-in-R

Looking at 120 years of Olympic history and discovering interesting trends, patterns and visualizing our findings using R.
RMarkdown
4
star
14

Excel-Macro-Remove-Empty-Rows

Macro to remove empty rows based on the first column in Excel document using Visual Basic ( Making a colleagues life easy )
Visual Basic
4
star
15

HackerRank-Python-Challenges-Solutions

The solutions of all my SQL HackerRank Python challenges
Python
3
star
16

Java-Programs

Practicing popular Java Programs
Java
2
star
17

Kafka-Producer-Consumer-Group-Message-Passing

Simple Custom Producer Consumer group demonstrating message passing in Kafka
Java
2
star
18

Retro-Reel-Recommender

Building a content-based recommendation engine API for the retro movie lovers (1900s) using NLP, Flask and Heroku.
Jupyter Notebook
2
star
19

FBI-Uniform-Crime-Reporting-Analytics

Analyzing FBI uniform major crimes reporting in every US state visualized on a Tableau dashboard. A data mining hackathon.
Jupyter Notebook
2
star
20

thomas-george-t.github.io

My very own space on the Internet! Portfolio and Personal Website. https://thomasgeorgethomas.com
1
star
21

Hackerrank-Functional-Programming-Scala

Hackerrank functional programming solutions in scala.
Scala
1
star