arfin-parween / sql-50-leetcode- Goto Github PK

View Code? Open in Web Editor NEW

This Repository contains SQL 50 Question with video solution of Leetcode If you are a beginner and looking to improve SQL or an experienced developer interested in exploring different concepts, this collection has something for you.

License: MIT License

sql-50-leetcode-'s Introduction

SQL 50 Leetcode

Hey There!

Please to my Youtube Channel

Lectures	Video Link	LeetCode Question	Solution
1) 1757. Recyclable and Low Fat Products
2) 584. Find Customer Referee
3) 595. Big Countries
4) 1148. Article Views I
5) 1683. Invalid Tweets
6) 1378. Replace Employee ID With The Unique Identifier
7) 1068. Product Sales Analysis I
8) 1581. Customer Who Visited but Did Not Make Any Transactions
9) 197. Rising Temperature
10) 1661. Average Time of Process per Machine
11) 577. Employee Bonus
12) 1280. Students and Examinations
13) 570. Managers with at Least 5 Direct Reports
14) 1934. Confirmation Rate
15) 620. Not Boring Movies
16) 1251. Average Selling Price
17) 1075. Project Employees I
18) 1633. Percentage of Users Attended a Contest
19) 1211. Queries Quality and Percentage
20) 1193. Monthly Transactions I
21) 1174. Immediate Food Delivery II
22) 550. Game Play Analysis IV
23) 2356. Number of Unique Subjects Taught by Each Teacher
24) 1141. User Activity for the Past 30 Days I
25) 1070. Product Sales Analysis III
26) 596. Classes More Than 5 Students
27) 1729. Find Followers Count
28) 619. Biggest Single Number
29) 1045. Customers Who Bought All Products
30) 1731. The Number of Employees Which Report to Each Employee
31) 1789. Primary Department for Each Employee
32) 610. Triangle Judgement
33) 180. Consecutive Numbers
34) 1164. Product Price at a Given Date
35) 1204. Last Person to Fit in the Bus
36) 1907. Count Salary Categories
37) 1978. Employees Whose Manager Left the Company
38) 626. Exchange Seats
39) 1341. Movie Rating
40) 1321. Restaurant Growth
41) 602. Friend Requests II: Who Has the Most Friends
42) 585. Investments in 2016
43) 185. Department Top Three Salaries
44) 1667. Fix Names in a Table
45) 1527. Patients With a Condition
46) 196. Delete Duplicate Emails
47) 176. Second Highest Salary
48) 1484. Group Sold Products By The Date
49) 1327. List the Products Ordered in a Period
50) 1517. Find Users With Valid E-Mails