Skip to content

Solutions to Problems For SQL on Leetcode, Hackerrank & DataLemur

Notifications You must be signed in to change notification settings

mdh266/SQL-Practice

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

71 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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
Monthly Transactions I Solution
Managers with at Least 5 Direct Reports 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
Restaurant Growth Solution
Game Play Analysis I Solution
Game Play Analysis IV Solution
Investments In 2016 Solution
Friend Requests II: Who Has the Most Friends Solution
Odd And Even Transactions Solution
Confirmation Rate Solution

DataLemur


Question Answer
Laptop vs. Mobile Viewership Solution
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
International Call Percentage Solution
Tweets' Rolling Average Solution
Top Three Salaries Solution
Histogram of Users and Purchases 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