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 }}
evolution99
/
AdvancedSQL_Interview
Public
forked from
NIteshx2/AdvancedSQL_Interview
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
AdvancedSQL_Interview
/
LeetCode
/
others
/
Copy path
Directory actions
More options
More options
Directory actions
More options
More options
Latest commit
History
History
History
master
Breadcrumbs
AdvancedSQL_Interview
/
LeetCode
/
others
/
Copy path
Top
Folders and files
Name
Name
Last commit message
Last commit date
parent directory
..
1045_Customers_Who_Bought_All_Products.sql
1045_Customers_Who_Bought_All_Products.sql
1050_Actors_and_Directors_Who_Cooperated_At_Least_Three_Times.sql
1050_Actors_and_Directors_Who_Cooperated_At_Least_Three_Times.sql
1068_Product_Sales_Analysis_I.sql
1068_Product_Sales_Analysis_I.sql
1069_Product_Sales_Analysis_II.sql
1069_Product_Sales_Analysis_II.sql
1070_Product_Sales_Analysis_III.sql
1070_Product_Sales_Analysis_III.sql
1075_Project_Employees_I.sql
1075_Project_Employees_I.sql
1076_Project_Employees_II.sql
1076_Project_Employees_II.sql
1077_Project_Employees_III.sql
1077_Project_Employees_III.sql
1082_Sales_Analysis_I.sql
1082_Sales_Analysis_I.sql
1083_Sales_Analysis_II.sql
1083_Sales_Analysis_II.sql
1084_Sales_Analysis_III.sql
1084_Sales_Analysis_III.sql
1097_Game_Play_Analysis_V.sql
1097_Game_Play_Analysis_V.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
1113_Reported_Posts.sql
1113_Reported_Posts.sql
1126_Active_Businesses.sql
1126_Active_Businesses.sql
1127_User_Purchase_Platform.sql
1127_User_Purchase_Platform.sql
1132_Reported_Posts_II.sql
1132_Reported_Posts_II.sql
1141_User_Activity_for_the_Past_30_Days_I.sql
1141_User_Activity_for_the_Past_30_Days_I.sql
1142_User_Activity_for_the_Past_30_Days_II.sql
1142_User_Activity_for_the_Past_30_Days_II.sql
1148_Article_Views_I.sql
1148_Article_Views_I.sql
1149_Article_Views_II.sql
1149_Article_Views_II.sql
1158_Market_Analysis_I.sql
1158_Market_Analysis_I.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
1173_Immediate_Food_Delivery_I.sql
1173_Immediate_Food_Delivery_I.sql
1174_Immediate_Food_Delivery_II.sql
1174_Immediate_Food_Delivery_II.sql
1179_Reformat_Department_Table.sql
1179_Reformat_Department_Table.sql
175_Combine_Two_Tables.sql
175_Combine_Two_Tables.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
181_Employees_Earning_More_Than_Their_Managers.sql
181_Employees_Earning_More_Than_Their_Managers.sql
182_Duplicate_Emails.sql
182_Duplicate_Emails.sql
183_Customers_Who_Never_Order.sql
183_Customers_Who_Never_Order.sql
184_Department_Highest_Salary.sql
184_Department_Highest_Salary.sql
185_Department_Top_Three_Salaries.sql
185_Department_Top_Three_Salaries.sql
196_Delete_Duplicate_Emails.sql
196_Delete_Duplicate_Emails.sql
197_Rising_Temperature.sql
197_Rising_Temperature.sql
262_Trips_and_Users.sql
262_Trips_and_Users.sql
569_Median_Employee_Salary.sql
569_Median_Employee_Salary.sql
570_Managers_with_at_Least_5_Direct_Reports.sql
570_Managers_with_at_Least_5_Direct_Reports.sql
571_Find_Median_Given_Frequency_of_Numbers.sql
571_Find_Median_Given_Frequency_of_Numbers.sql
574_Winning_Candidate.sql
574_Winning_Candidate.sql
577_Employee_Bonus.sql
577_Employee_Bonus.sql
578_Get_Highest_Answer_Rate_Question.sql
578_Get_Highest_Answer_Rate_Question.sql
579_Find_Cumulative_Salary_of_an_Employee.sql
579_Find_Cumulative_Salary_of_an_Employee.sql
580_Count_Student_Number_in_Departments.sql
580_Count_Student_Number_in_Departments.sql
584_Find_Customer_Referee.sql
584_Find_Customer_Referee.sql
585_Investments_in_2016.sql
585_Investments_in_2016.sql
586_Customer_Placing_the_Largest_Number_of_Orders.sql
586_Customer_Placing_the_Largest_Number_of_Orders.sql
595_Big_Countries.sql
595_Big_Countries.sql
596_Classes_More_Than_5_Students.sql
596_Classes_More_Than_5_Students.sql
597_Friend_Requests_I-_Overall_Acceptance_Rate.sql
597_Friend_Requests_I-_Overall_Acceptance_Rate.sql
601_Human_Traffic_of_Stadium.sql
601_Human_Traffic_of_Stadium.sql
602_Friend_Requests_II-_Who_Has_the_Most_Friends.sql
602_Friend_Requests_II-_Who_Has_the_Most_Friends.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
610_Triangle_Judgement.sql
610_Triangle_Judgement.sql
612_Shortest_Distance_in_a_Plane.sql
612_Shortest_Distance_in_a_Plane.sql
613_Shortest_Distance_in_a_Line.sql
613_Shortest_Distance_in_a_Line.sql
614_Second_Degree_Follower.sql
614_Second_Degree_Follower.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
619_Biggest_Single_Number.sql
619_Biggest_Single_Number.sql
620_Not_Boring_Movies.sql
620_Not_Boring_Movies.sql
626_Exchange_Seats.sql
626_Exchange_Seats.sql
627_Swap_Salary.sql
627_Swap_Salary.sql
View all files
You can’t perform that action at this time.