Skip to content
Navigation Menu
Sign in
Appearance settings
Platform
AI CODE CREATION
GitHub Copilot
Write better code with AI
GitHub Copilot app
Direct agents from issue to merge
MCP Registry
Integrate external tools
DEVELOPER WORKFLOWS
Actions
Automate any workflow
Codespaces
Instant dev environments
Issues
Plan and track work
Code Review
Manage code changes
Code Quality
Enforce quality at merge
APPLICATION SECURITY
GitHub Advanced Security
Find and fix vulnerabilities
Code security
Secure your code as you build
Secret protection
Stop leaks before they start
EXPLORE
Why GitHub
Documentation
Blog
Changelog
Marketplace
View all features
Solutions
BY COMPANY SIZE
Enterprises
Small and medium teams
Startups
Nonprofits
BY USE CASE
App Modernization
DevSecOps
DevOps
CI/CD
View all use cases
BY INDUSTRY
Healthcare
Financial services
Manufacturing
Government
View all industries
View all solutions
Resources
EXPLORE BY TOPIC
AI
Software Development
DevOps
Security
View all topics
EXPLORE BY TYPE
Customer stories
Events & webinars
Ebooks & reports
Business insights
GitHub Skills
SUPPORT & SERVICES
Documentation
Customer support
Community forum
Trust center
Partners
View all resources
Open Source
COMMUNITY
GitHub Sponsors
Fund open source developers
PROGRAMS
Security Lab
Maintainer Community
Accelerator
GitHub Stars
Archive Program
REPOSITORIES
Topics
Trending
Collections
Enterprise
ENTERPRISE SOLUTIONS
Enterprise platform
AI-powered developer platform
AVAILABLE ADD-ONS
GitHub Advanced Security
Enterprise-grade security features
Copilot for Business
Enterprise-grade AI features
Premium Support
Enterprise-grade 24/7 support
Pricing
Search
/
Sign in
Sign up
Appearance settings
You signed in with another tab or window.
Reload
to refresh your session.
You signed out in another tab or window.
Reload
to refresh your session.
You switched accounts on another tab or window.
Reload
to refresh your session.
Dismiss alert
{{ message }}
smartrobin
/
LeetCode-SQL-Summary
Public
forked from
siqichen-usc/LeetCode-SQL-Summary
Notifications
You must be signed in to change notification settings
Fork
0
Star
0
Code
Pull requests
0
Actions
Projects
Security and quality
0
Insights
Additional navigation options
Code
Pull requests
Actions
Projects
Security and quality
Insights
Files
Expand file tree
master
Breadcrumbs
LeetCode-SQL-Summary
/
Window-Function
/
Copy path
Directory actions
More options
More options
Directory actions
More options
More options
Latest commit
History
History
History
master
Breadcrumbs
LeetCode-SQL-Summary
/
Window-Function
/
Copy path
Top
Folders and files
Name
Name
Last commit message
Last commit date
parent directory
..
1070_Product_Sales_Analysis_III.sql
1070_Product_Sales_Analysis_III.sql
1077_Project_Employees_III.sql
1077_Project_Employees_III.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
1127_User_Purchase_Platform.sql
1127_User_Purchase_Platform.sql
1159_Market_Analysis_II.sql
1159_Market_Analysis_II.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
1194_Tournament_Winners.sql
1194_Tournament_Winners.sql
1204_Last_Person_to_Fit_in_the_Elevator.sql
1204_Last_Person_to_Fit_in_the_Elevator.sql
1225_Report_Contiguous_Dates.sql
1225_Report_Contiguous_Dates.sql
1285_Find_the_Start_and_End_Number_of_Continuous_Ranges.sql
1285_Find_the_Start_and_End_Number_of_Continuous_Ranges.sql
1303_Find_the_Team_Size.sql
1303_Find_the_Team_Size.sql
1308_Running_Total_for_Different_Genders.sql
1308_Running_Total_for_Different_Genders.sql
1321_Restaurant_Growth.sql
1321_Restaurant_Growth.sql
1355_Activity_Participants.sql
1355_Activity_Participants.sql
1369_Get_the_Second_Most_Recent_Activity.sql
1369_Get_the_Second_Most_Recent_Activity.sql
1412_Find_The_Quiet_Students_in_All_Exams.sql
1412_Find_The_Quiet_Students_in_All_Exams.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
180_Consecutive_Numbers.sql
180_Consecutive_Numbers.sql
184_Department_Highest_Salary.sql
184_Department_Highest_Salary.sql
185_Department_Top_Three_Salaries.sql
185_Department_Top_Three_Salaries.sql
197_Rising_Temperature.sql
197_Rising_Temperature.sql
512_Game_Play_Analysis_II.sql
512_Game_Play_Analysis_II.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
569_Median_Employee_Salary.sql
569_Median_Employee_Salary.sql
571_Find_Median_Given_Frequency_of_Numbers.sql
571_Find_Median_Given_Frequency_of_Numbers.sql
579_Find_Cumulative_Salary_of_an_Employee.sql
579_Find_Cumulative_Salary_of_an_Employee.sql
585_Investments_in_2016.sql
585_Investments_in_2016.sql
601_Human_Traffic_of_Stadium.sql
601_Human_Traffic_of_Stadium.sql
603_Consecutive_Available_Seats.sql
603_Consecutive_Available_Seats.sql
613_Shortest_Distance_in_a_Line.sql
613_Shortest_Distance_in_a_Line.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
Window-Function.md
Window-Function.md
View all files
You can’t perform that action at this time.