Giter Club home page Giter Club logo

10-days-of-sql's Introduction

10 Days of SQL

Polish your SQL skills..!!

This repo have problems of SQL from Leetcode.

Problems

Day 1: Select

Problem No. Difficulty Title
595 Easy Big Countries
1757 Easy Recyclable and Low Fat Products
584 Easy Find Customer Referee
183 Easy Customers Who Never Order

Day 2: Select & Order

Problem No. Difficulty Title
1873 Easy Calculate Special Bonus
627 Easy Swap Salary
196 Easy Delete Duplicate Emails

Day 3: String Processing Functions

Problem No. Difficulty Title
1667 Easy Fix Names in a Table
1484 Easy Group Sold Products By The Date
1527 Easy Patients With a Condition

Day 4: Union & Select

Problem No. Difficulty Title
1965 Easy Employees With Missing Information
1795 Easy Rearrange Products Table
608 Medium Tree Node
176 Medium Second Highest Salary

Day 5: Union

Problem No. Difficulty Title
175 Easy Combine Two Tables
1581 Easy Customer Who Visited but Did Not Make Any Transactions
1148 Easy Article Views I

Day 6: Union

Problem No. Difficulty Title
197 Easy Rising Temperature
607 Easy Sales Person

Day 7: Function

Problem No. Difficulty Title
1141 Easy User Activity for the Past 30 Days I
1693 Easy Daily Leads and Partners
1729 Easy Find Followers Count

Day 8: Function

Problem No. Difficulty Title
586 Easy Customer Placing the Largest Number of Orders
511 Easy Game Play Analysis I
1890 Easy The Latest Login in 2020
1741 Easy Find Total Time Spent by Each Employee

Day 9: Control of Flow

Problem No. Difficulty Title
1393 Medium Capital Gain/Loss
1407 Easy Top Travellers
1158 Medium Market Analysis I

Day 10: Where

Problem No. Difficulty Title
182 Easy Duplicate Emails
1050 Easy Actors and Directors Who Cooperated At Least Three Times
1587 Easy Bank Account Summary II
1084 Easy Sales Analysis III

Strategies to solve these problems:

-> Read the question carefully.

-> Read the tutorial if you are not familiar with the topic.

-> Go to Leetcode’s discussion board to get some hints or solutions.

-> Try to understand the solutions.

-> Practice with the same question again.

10-days-of-sql's People

Contributors

ayush-pr0 avatar net-user avatar net-user0 avatar ayush-geeks avatar gituser9911 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.