Skip to content

developer-Akhil/sql_leetcodes

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Leetcodes SQL Questions

It contains details of the leetcode SQL queries, including their schema and table structure for locked questions.

175 Combine Two Tables

176 Second Highest Salary

177 Nth Highest Salary

178 Rank Scores

180 Consecutive Numbers

181 Employees Earning More Than Their Managers

182 Duplicate Emails

183 Customers Who Never Order

184 Department Highest Salary

185 Department Top Three Salaries

196 Delete Duplicate Emails

197 Rising Temperature

512 Game Play Analysis II

579 Find Cumulative Salary of an Employee

580 Count Student Number in Departments

597 Friend Requests I: Overall Acceptance Rate

602 Friend Requests II: Who Has the Most Friends

603 Consecutive Available Seats

626 Exchange Seats

1077 Project Employees III

1082 Sales Analysis I

1098 Unpopular Books

1126 Active Businesses

1173 Immediate Food Delivery I

1211 Queries Quality and Percentage

1241 Number of Comments per Post

1285 Find the Start and End Number of Continuous Ranges

1327 List the Products Ordered in a Period

1355 1355. Activity Participants

1393 Capital Gain/Loss

1407 Top Travellers

1445 Apples & Oranges

1501 Countries You Can Safely Invest In

1511 Customer Order Frequency

1517 Find Users With Valid E-Mails

1532 The Most Recent Three Orders

1571 Warehouse Manager

1699 Number of Calls Between Two Persons

1709 Biggest Window Between Visits

1741 Find Total Time Spent by Each Employee

1783 Grand Slam Titles

1795 Rearrange Products Table

1811 Find Interview Candidates

1821 Find Customers With Positive Revenue this Year

1831 Maximum Transaction Each Day

1875 Group Employees of the Same Salary

1978 Employees Whose Manager Left the Company

1934 Confirmation Rate

1988 Find Cutoff Score for Each School

2026 Low-Quality Problems

2066 Account Balance

2072 The Winner University

2041 Accepted Candidates From the Interviews

2082 The Number of Rich Customers

2084 Drop Type 1 Orders for Customers With Type 0 Orders

2112 The Airport With the Most Traffic

2118 Build the Equation

2159 Order Two Columns Independently

2175 The Change in Global Rankings

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published