Giter VIP home page Giter VIP logo

sql-practice's Introduction

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

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

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

sql-practice's People

Contributors

mdh266 avatar imajkumar 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.