mdh266/SQL-Practice mdh266/SQL-Practice

  • Stars
    star
    128
  • Rank 281,044 (Top 6 %)
  • Language
  • Created about 7 years ago
  • Updated over 1 year ago
Twitter logo Share LinkedIn logo Share Facebook logo Share
mdh266/SQL-Practice
github

mdh266

Reviews

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

Repository Details

Solutions to Problems For SQL on Leetcode, Hackerrank & DataLemur

Practice SQL Scripts From Interview Prep Websites

These are scripts that answer questions from leetcode, DataLemur, hackerank and sqlzoo. Links to questions and my answers are below!

LeetCode

Question Answer
Employees earn more than their managers Solution
Second highest salaries Solution
Customers who never order Solution
Duplicate Emails Solution
Rising Temperatures Solution
Department Top Three Salaries Solution
N-th Highest Salary Solution
Department Highest Salary Solution
Rank Scores Solution
Not Boring Movies Solution
Exchange Seats Solution
Consecutive Numbers Solution
Human Traffice Of Stadium Solution
Trips and Users Solution
Capital Gains/Loss Solution
Market Analysis I Solution
Tree Node Solution

DataLemur

Question Answer
Average Review Ratings Solution
Matching Skills Solution
Odd and Even Measurements Solution
Y-on-Y Growth Rate Solution
Page With No Likes Solution
Frequently Purchased Pairs Solution
Supercloud Customer Solution
Sending vs. Opening Snap Solution
User's Third Transaction Solution
Repeated Payments Solution
Compressed Mode Solution
Signup Activation Rate Solution
Highest-Grossing Items Solution
Top 5 Artists Solution

Hacker Rank

Question Answer
Japanese Cities Solution
Earnings of employees Solution
Weather Observation Station 8 Soluton
Weather Observation Station 9 Soluton
More Than 75 Marks Solution
The Pads Solution
Binary Search Tree 1 Solution

SQLZoo

Question Answer
Richer Than UK Solution
Bigger Than Every Country In Europe Solution
Neighbours of Argentina and Australia Solution
Teams that have coach Fernando Santos Solution
Busy years for John Travolta Solution

More Repositories

1

AirflowDataPipeline

Example of an ETL Pipeline using Airflow
Python
31
star
2

AirflowETL

Blog post on ETL pipelines with Airflow
Jupyter Notebook
19
star
3

RecommenderSystems

Recommender Systems and Collaborative Filtering
Jupyter Notebook
17
star
4

TextClassificationApp

Building and Deploying A Serverless Text Classification Web App
Jupyter Notebook
16
star
5

NYCBuildingEnergyUse

Creating Regression Models Of Building Emissions On Google Cloud
Jupyter Notebook
16
star
6

RandomForests

Random Forest Library In Python Compatible with Scikit-Learn
Python
13
star
7

Distributed_Poisson_Solver

Distributed Poisson Equation Solver Using The Local Discontinuous Galerkin Method
C++
6
star
8

PECS-1D

Photoelectrochemical Solar Cell Simulator in 1D
C++
6
star
9

CrimeTime

Python web application for exploring and forecasting crime rates in NYC
HTML
5
star
10

Semiconductor_Device_Simulator

Semiconductor Device Simulator in 2D and 3D
C++
5
star
11

Advection_Solver

Solves the steady-state advection equation using the discontinuous Galerkin method.
C++
4
star
12

TwitterSentimentAnalysis

Twitter Sentiment Analysis using Spark, MongoDB, and Google Cloud
Jupyter Notebook
3
star
13

Wikimedia_Challenge

Analyzing click-through rates from Wikimedia
Jupyter Notebook
3
star
14

PECS

Photoelctrochemical Solar Cell Simulator
C++
3
star
15

Multithreaded_Poisson_Solver

Multithreaded Poisson Equation solver which uses the mixed finite element method
C++
2
star
16

OpenMP_Practice

Practice Codes For Multithreading With C/C++ and OpenMP
C
1
star
17

IntroToBokeh

A Quick Intro To Interactive Visualizations With Bokeh
Jupyter Notebook
1
star
18

ScalaWebApp

A simple HelloWorld Scala Web App with Scalatra
Scala
1
star
19

Java-Practice

Practice Problems In Java
Java
1
star
20

KMeans

Creating A Scikit-Learn Compatable Clustering Algorithm
Jupyter Notebook
1
star
21

Cancer_Detection

Classification Models For Cancer Detection
Jupyter Notebook
1
star