Skip to content

shsharma14/SQL-Leetcode

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
1083. Sales Analysis II.sql
1083. Sales Analysis II.sql
 
 
1107. New Users Daily Count.sql
1107. New Users Daily Count.sql
 
 
1127. User Purchase Platform.sql
1127. User Purchase Platform.sql
 
 
1142. User Activity for the Past 30 Days II.sql
1142. User Activity for the Past 30 Days II.sql
 
 
1164. Product Price at a Given Date.sql
1164. Product Price at a Given Date.sql
 
 
1204. Last Person to Fit in the Bus.sql
1204. Last Person to Fit in the Bus.sql
 
 
1205. Monthly Transactions II.sql
1205. Monthly Transactions II.sql
 
 
1225. Report Contiguous Dates.sql
1225. Report Contiguous Dates.sql
 
 
1241. Number of Comments per Post.sql
1241. Number of Comments per Post.sql
 
 
1270. All People Report to the Given Manager.sql
1270. All People Report to the Given Manager.sql
 
 
1280. Students and Examinations.sql
1280. Students and Examinations.sql
 
 
1285. Find the Start and End Number of Continuous Ranges.sql
1285. Find the Start and End Number of Continuous Ranges.sql
 
 
1308. Running Total for Different Genders.sql
1308. Running Total for Different Genders.sql
 
 
1321. Restaurant Growth.sql
1321. Restaurant Growth.sql
 
 
1322. Ads Performance.sql
1322. Ads Performance.sql
 
 
1384. Total Sales Amount by Year.sql
1384. Total Sales Amount by Year.sql
 
 
1398. Customers Who Bought Products A and B but Not C.sql
1398. Customers Who Bought Products A and B but Not C.sql
 
 
1407. Top Travellers.sql
1407. Top Travellers.sql
 
 
1412. Find the Quiet Students in All Exams.sql
1412. Find the Quiet Students in All Exams.sql
 
 
1454. Active Users.sql
1454. Active Users.sql
 
 
1484. Group Sold Products By The Date.sql
1484. Group Sold Products By The Date.sql
 
 
1532. The Most Recent Three Orders.sql
1532. The Most Recent Three Orders.sql
 
 
1613. Find the Missing IDs.sql
1613. Find the Missing IDs.sql
 
 
1699. Number of Calls Between Two Persons.sql
1699. Number of Calls Between Two Persons.sql
 
 
1747. Leetflex Banned Accounts.sql
1747. Leetflex Banned Accounts.sql
 
 
178. Rank Scores.sql
178. Rank Scores.sql
 
 
1783. Grand Slam Titles.sql
1783. Grand Slam Titles.sql
 
 
180. Three_Consecutive_Nums.sql
180. Three_Consecutive_Nums.sql
 
 
1811. Find Interview Candidates.sql
1811. Find Interview Candidates.sql
 
 
184. Department Highest Salary.sql
184. Department Highest Salary.sql
 
 
1841. League Statistics.sql
1841. League Statistics.sql
 
 
1951. All the Pairs With the Maximum Number of Common Followers.sql
1951. All the Pairs With the Maximum Number of Common Followers.sql
 
 
1965. Employees With Missing Information.sql
1965. Employees With Missing Information.sql
 
 
197. Rising Temperature.sql
197. Rising Temperature.sql
 
 
1972. First and Last Call On the Same Day.sql
1972. First and Last Call On the Same Day.sql
 
 
2142. The Number of Passengers in Each Bus I.sql
2142. The Number of Passengers in Each Bus I.sql
 
 
2228. Users With Two Purchases Within Seven Days.sql
2228. Users With Two Purchases Within Seven Days.sql
 
 
2238. Number of Times a Driver Was a Passenger.sql
2238. Number of Times a Driver Was a Passenger.sql
 
 
2292. Products With Three or More Orders in Two Consecutive Years.sql
2292. Products With Three or More Orders in Two Consecutive Years.sql
 
 
2298. Tasks Count in the Weekend.sql
2298. Tasks Count in the Weekend.sql
 
 
2308. Arrange Table by Gender.sql
2308. Arrange Table by Gender.sql
 
 
2339. All the Matches of the League.sql
2339. All the Matches of the League.sql
 
 
2388. Change Null Values in a Table to the Previous Value.sql
2388. Change Null Values in a Table to the Previous Value.sql
 
 
262. Trips and Users.sql
262. Trips and Users.sql
 
 
550. Game Play Analysis IV.sql
550. Game Play Analysis IV.sql
 
 
601. Human Traffic of Stadium.sql
601. Human Traffic of Stadium.sql
 
 
603. Consecutive Available Seats.sql
603. Consecutive Available Seats.sql
 
 
607. Sales Person.sql
607. Sales Person.sql
 
 
608. Tree Node.sql
608. Tree Node.sql
 
 
615. Average Salary- Departments VS Company.sql
615. Average Salary- Departments VS Company.sql
 
 
618. Students Report By Geography.sql
618. Students Report By Geography.sql
 
 
626. Exchange Seats.sql
626. Exchange Seats.sql
 
 
Department_Top_Three_Salaries.sql
Department_Top_Three_Salaries.sql
 
 
Hackerrank_Learnings.sql
Hackerrank_Learnings.sql
 
 
Median.sql
Median.sql
 
 
README.md
README.md
 
 
SQLQuery14.sql
SQLQuery14.sql
 
 
SQLQuery2.sql
SQLQuery2.sql
 
 
Salary_Greater_Than_Manager.sql
Salary_Greater_Than_Manager.sql
 
 

Repository files navigation

SQL-Leetcode

These are some of the SQL questions on Leetcode that I have solved using window functions (RANK, DENSE_RANK, ROW_NUMBER, LEAD, LAG, FIRST_VALUE, LAST_VALUE), JOINS (INNER, LEFT, SELF), GROUP BY, HAVING, WHERE, ORDER BY, CASE statements.

About

No description, website, or topics provided.

Resources

Readme
Activity

Stars

1 star

Watchers

1 watching

Forks

1 fork
Report repository

Releases

No releases published

Packages

No packages published

Languages