10 days of sql

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.