Skip to content

Latest commit

 

History

History

medium

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
1045. Customers Who Bought All Products.sql
1045. Customers Who Bought All Products.sql
 
 
1070. Product Sales Analysis III.sql
1070. Product Sales Analysis III.sql
 
 
1077. Project Employees III.sql
1077. Project Employees III.sql
 
 
1098. Unpopular Books.sql
1098. Unpopular Books.sql
 
 
1107. New Users Daily Count.sql
1107. New Users Daily Count.sql
 
 
1112. Highest Grade For Each Student.sql
1112. Highest Grade For Each Student.sql
 
 
1126. Active Businesses.sql
1126. Active Businesses.sql
 
 
1132. Reported Posts II.sql
1132. Reported Posts II.sql
 
 
1149. Article Views II.sql
1149. Article Views II.sql
 
 
1158. Market Analysis I.sql
1158. Market Analysis I.sql
 
 
1164. Product Price at a Given Date.sql
1164. Product Price at a Given Date.sql
 
 
1174. Immediate Food Delivery II.sql
1174. Immediate Food Delivery II.sql
 
 
1193. Monthly Transactions I.sql
1193. Monthly Transactions I.sql
 
 
1204. Last Person to Fit in the Elevator.sql
1204. Last Person to Fit in the Elevator.sql
 
 
1205. Monthly Transactions II.sql
1205. Monthly Transactions II.sql
 
 
1212. Team Scores in Football Tournament.sql
1212. Team Scores in Football Tournament.sql
 
 
1264. Page Recommendations.sql
1264. Page Recommendations.sql
 
 
1270. All People Report to the Given Manager.sql
1270. All People Report to the Given Manager.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
 
 
1341. Movie Rating.sql
1341. Movie Rating.sql
 
 
1355. Activity Participants.sql
1355. Activity Participants.sql
 
 
1364. Number of Trusted Contacts of a Customer.sql
1364. Number of Trusted Contacts of a Customer.sql
 
 
1393. Capital Gain Loss.sql
1393. Capital Gain Loss.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
 
 
1440. Evaluate Boolean Expression.sql
1440. Evaluate Boolean Expression.sql
 
 
1445. Apples & Oranges.sql
1445. Apples & Oranges.sql
 
 
1454. Active Users.sql
1454. Active Users.sql
 
 
1459. Rectangles Area.sql
1459. Rectangles Area.sql
 
 
1468. Calculate Salaries.sql
1468. Calculate Salaries.sql
 
 
1501. Countries You Can Safely Invest In.sql
1501. Countries You Can Safely Invest In.sql
 
 
1532. The Most Recent Three Orders.sql
1532. The Most Recent Three Orders.sql
 
 
1549. The Most Recent Orders for Each Product.sql
1549. The Most Recent Orders for Each Product.sql
 
 
1555. Bank Account Summary.sql
1555. Bank Account Summary.sql
 
 
1596. The Most Frequently Ordered Products for Each Customer.sql
1596. The Most Frequently Ordered Products for Each Customer.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
 
 
1709. Biggest Window Between Visits.sql
1709. Biggest Window Between Visits.sql
 
 
1715. Count Apples and Oranges.sql
1715. Count Apples and Oranges.sql
 
 
1747. Leetflex Banned Accounts.sql
1747. Leetflex Banned Accounts.sql
 
 
176. Second Highest Salary.sql
176. Second Highest Salary.sql
 
 
177. Nth Highest Salary.sql
177. Nth Highest Salary.sql
 
 
178. Rank Scores.sql
178. Rank Scores.sql
 
 
1783. Grand Slam Titles.sql
1783. Grand Slam Titles.sql
 
 
180. Consecutive Numbers.sql
180. Consecutive Numbers.sql
 
 
1811. Find Interview Candidates (Medium).sql
1811. Find Interview Candidates (Medium).sql
 
 
1831. Maximum Transaction Each Day (Medium).sql
1831. Maximum Transaction Each Day (Medium).sql
 
 
184. Department Highest Salary.sql
184. Department Highest Salary.sql
 
 
1841. League Statistics (Medium).sql
1841. League Statistics (Medium).sql
 
 
1843. Suspicious Bank Accounts (Medium).sql
1843. Suspicious Bank Accounts (Medium).sql
 
 
1867. Orders With Maximum Quantity Above Average (Medium).sql
1867. Orders With Maximum Quantity Above Average (Medium).sql
 
 
1875. Group Employees of the Same Salary (Medium).sql
1875. Group Employees of the Same Salary (Medium).sql
 
 
1907. Count Salary Categories (Medium).sql
1907. Count Salary Categories (Medium).sql
 
 
1934. Confirmation Rate (Medium).sql
1934. Confirmation Rate (Medium).sql
 
 
1949. Strong Friendship (Medium).sql
1949. Strong Friendship (Medium).sql
 
 
1951. All the Pairs With the Maximum Number of Common Followers (Medium).sql
1951. All the Pairs With the Maximum Number of Common Followers (Medium).sql
 
 
1988. Find Cutoff Score for Each School (Medium).sql
1988. Find Cutoff Score for Each School (Medium).sql
 
 
1990. Count the Number of Experiments (Medium).sql
1990. Count the Number of Experiments (Medium).sql
 
 
2020. Number of Accounts That Did Not Stream (Medium).sql
2020. Number of Accounts That Did Not Stream (Medium).sql
 
 
2041. Accepted Candidates From the Interviews (Medium).sql
2041. Accepted Candidates From the Interviews (Medium).sql
 
 
2051. The Category of Each Member in the Store (Medium).sql
2051. The Category of Each Member in the Store (Medium).sql
 
 
2066. Account Balance (Medium).sql
2066. Account Balance (Medium).sql
 
 
2084. Drop Type 1 Orders for Customers With Type 0 Orders (Medium).sql
2084. Drop Type 1 Orders for Customers With Type 0 Orders (Medium).sql
 
 
2112. The Airport With the Most Traffic (Medium).sql
2112. The Airport With the Most Traffic (Medium).sql
 
 
2142. The Number of Passengers in Each Bus I (Medium).sql
2142. The Number of Passengers in Each Bus I (Medium).sql
 
 
2159. Order Two Columns Independently (Medium).sql
2159. Order Two Columns Independently (Medium).sql
 
 
2175. The Change in Global Rankings (Medium).sql
2175. The Change in Global Rankings (Medium).sql
 
 
2228. Users With Two Purchases Within Seven Days (Medium).sql
2228. Users With Two Purchases Within Seven Days (Medium).sql
 
 
2238. Number of Times a Driver Was a Passenger (Medium).sql
2238. Number of Times a Driver Was a Passenger (Medium).sql
 
 
2292. Products With Three or More Orders in Two Consecutive Years (Medium).sql
2292. Products With Three or More Orders in Two Consecutive Years (Medium).sql
 
 
2298. Tasks Count in the Weekend (Medium).sql
2298. Tasks Count in the Weekend (Medium).sql
 
 
2308. Arrange Table by Gender (Medium).sql
2308. Arrange Table by Gender (Medium).sql
 
 
2314. The First Day of the Maximum Recorded Degree in Each City (Medium).sql
2314. The First Day of the Maximum Recorded Degree in Each City (Medium).sql
 
 
2324. Product Sales Analysis IV (Medium).sql
2324. Product Sales Analysis IV (Medium).sql
 
 
2346. Compute the Rank as a Percentage (Medium).sql
2346. Compute the Rank as a Percentage (Medium).sql
 
 
2372. Calculate the Influence of Each Salesperson (Medium).sql
2372. Calculate the Influence of Each Salesperson (Medium).sql
 
 
2388. Change Null Values in a Table to the Previous Value (Medium).sql
2388. Change Null Values in a Table to the Previous Value (Medium).sql
 
 
2394. Employees With Deductions (Medium).sql
2394. Employees With Deductions (Medium).sql
 
 
534. Game Play Analysis III.sql
534. Game Play Analysis III.sql
 
 
550. Game Play Analysis IV.sql
550. Game Play Analysis IV.sql
 
 
570. Managers with at Least 5 Direct Reports.sql
570. Managers with at Least 5 Direct Reports.sql
 
 
574. Winning Candidate.sql
574. Winning Candidate.sql
 
 
578. Get Highest Answer Rate Question.sql
578. Get Highest Answer Rate Question.sql
 
 
580. Count Student Number in Departments.sql
580. Count Student Number in Departments.sql
 
 
585. Investments in 2016.sql
585. Investments in 2016.sql
 
 
602. Friend Requests II: Who Has the Most Friends.sql
602. Friend Requests II: Who Has the Most Friends.sql
 
 
608. Tree Node.sql
608. Tree Node.sql
 
 
612. Shortest Distance in a Plane.sql
612. Shortest Distance in a Plane.sql
 
 
614. Second Degree Follower.sql
614. Second Degree Follower.sql
 
 
626. Exchange Seats.sql
626. Exchange Seats.sql
 
 
close