René's URL Explorer Experiment


Title: GitHub - chz07/LeetCode-SQL-Summary: *Summary of 102 LeetCode SQL questions* This note aims to help people learn and review SQL efficiently. The first draft mainly focuses on T-SQL/MS SQL Server.

Open Graph Title: GitHub - chz07/LeetCode-SQL-Summary: *Summary of 102 LeetCode SQL questions* This note aims to help people learn and review SQL efficiently. The first draft mainly focuses on T-SQL/MS SQL Server.

X Title: GitHub - chz07/LeetCode-SQL-Summary: *Summary of 102 LeetCode SQL questions* This note aims to help people learn and review SQL efficiently. The first draft mainly focuses on T-SQL/MS SQL Server.

Description: *Summary of 102 LeetCode SQL questions* This note aims to help people learn and review SQL efficiently. The first draft mainly focuses on T-SQL/MS SQL Server. - chz07/LeetCode-SQL-Summary

Open Graph Description: *Summary of 102 LeetCode SQL questions* This note aims to help people learn and review SQL efficiently. The first draft mainly focuses on T-SQL/MS SQL Server. - chz07/LeetCode-SQL-Summary

X Description: *Summary of 102 LeetCode SQL questions* This note aims to help people learn and review SQL efficiently. The first draft mainly focuses on T-SQL/MS SQL Server. - chz07/LeetCode-SQL-Summary

Opengraph URL: https://github.com/chz07/LeetCode-SQL-Summary

X: @github

direct link

Domain: patch-diff.githubusercontent.com

route-pattern/:user_id/:repository
route-controllerfiles
route-actiondisambiguate
fetch-noncev2:869038a1-56f7-eb81-c74b-d53b3c6dbb92
current-catalog-service-hashf3abb0cc802f3d7b95fc8762b94bdcb13bf39634c40c357301c4aa1d67a256fb
request-idAFC8:4DECD:5615A55:6F14B82:697578F3
html-safe-nonce4411e3dfe398958d7dbd93df6935a6996c848f29d799adcf7f84c980ccd922a9
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJBRkM4OjRERUNEOjU2MTVBNTU6NkYxNEI4Mjo2OTc1NzhGMyIsInZpc2l0b3JfaWQiOiIxMjYzODE5ODE2ODE2NzAzNzMyIiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0=
visitor-hmac978572bd3eb3f64dec30589616df735ec83af4a7ce65caca601abe92d3b74489
hovercard-subject-tagrepository:314058952
github-keyboard-shortcutsrepository,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location//
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/chz07/LeetCode-SQL-Summary
twitter:imagehttps://opengraph.githubassets.com/a52c566b87461956c9eca765fc2c73da57f9d39218ad34860d6d69683a7ceab4/chz07/LeetCode-SQL-Summary
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/a52c566b87461956c9eca765fc2c73da57f9d39218ad34860d6d69683a7ceab4/chz07/LeetCode-SQL-Summary
og:image:alt*Summary of 102 LeetCode SQL questions* This note aims to help people learn and review SQL efficiently. The first draft mainly focuses on T-SQL/MS SQL Server. - chz07/LeetCode-SQL-Summary
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
None4a4bf5f4e28041a9d2e5c107d7d20b78b4294ba261cab243b28167c16a623a1f
turbo-cache-controlno-preview
go-importgithub.com/chz07/LeetCode-SQL-Summary git https://github.com/chz07/LeetCode-SQL-Summary.git
octolytics-dimension-user_id2928315
octolytics-dimension-user_loginchz07
octolytics-dimension-repository_id314058952
octolytics-dimension-repository_nwochz07/LeetCode-SQL-Summary
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forktrue
octolytics-dimension-repository_parent_id248878121
octolytics-dimension-repository_parent_nwosiqichen-usc/LeetCode-SQL-Summary
octolytics-dimension-repository_network_root_id248878121
octolytics-dimension-repository_network_root_nwosiqichen-usc/LeetCode-SQL-Summary
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release488b30e96dfd057fbbe44c6665ccbc030b729dde
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary#start-of-content
https://patch-diff.githubusercontent.com/
Sign in https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2Fchz07%2FLeetCode-SQL-Summary
GitHub CopilotWrite better code with AIhttps://github.com/features/copilot
GitHub SparkBuild and deploy intelligent appshttps://github.com/features/spark
GitHub ModelsManage and compare promptshttps://github.com/features/models
MCP RegistryNewIntegrate external toolshttps://github.com/mcp
ActionsAutomate any workflowhttps://github.com/features/actions
CodespacesInstant dev environmentshttps://github.com/features/codespaces
IssuesPlan and track workhttps://github.com/features/issues
Code ReviewManage code changeshttps://github.com/features/code-review
GitHub Advanced SecurityFind and fix vulnerabilitieshttps://github.com/security/advanced-security
Code securitySecure your code as you buildhttps://github.com/security/advanced-security/code-security
Secret protectionStop leaks before they starthttps://github.com/security/advanced-security/secret-protection
Why GitHubhttps://github.com/why-github
Documentationhttps://docs.github.com
Bloghttps://github.blog
Changeloghttps://github.blog/changelog
Marketplacehttps://github.com/marketplace
View all featureshttps://github.com/features
Enterpriseshttps://github.com/enterprise
Small and medium teamshttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
App Modernizationhttps://github.com/solutions/use-case/app-modernization
DevSecOpshttps://github.com/solutions/use-case/devsecops
DevOpshttps://github.com/solutions/use-case/devops
CI/CDhttps://github.com/solutions/use-case/ci-cd
View all use caseshttps://github.com/solutions/use-case
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
View all industrieshttps://github.com/solutions/industry
View all solutionshttps://github.com/solutions
AIhttps://github.com/resources/articles?topic=ai
Software Developmenthttps://github.com/resources/articles?topic=software-development
DevOpshttps://github.com/resources/articles?topic=devops
Securityhttps://github.com/resources/articles?topic=security
View all topicshttps://github.com/resources/articles
Customer storieshttps://github.com/customer-stories
Events & webinarshttps://github.com/resources/events
Ebooks & reportshttps://github.com/resources/whitepapers
Business insightshttps://github.com/solutions/executive-insights
GitHub Skillshttps://skills.github.com
Documentationhttps://docs.github.com
Customer supporthttps://support.github.com
Community forumhttps://github.com/orgs/community/discussions
Trust centerhttps://github.com/trust-center
Partnershttps://github.com/partners
GitHub SponsorsFund open source developershttps://github.com/sponsors
Security Labhttps://securitylab.github.com
Maintainer Communityhttps://maintainers.github.com
Acceleratorhttps://github.com/accelerator
Archive Programhttps://archiveprogram.github.com
Topicshttps://github.com/topics
Trendinghttps://github.com/trending
Collectionshttps://github.com/collections
Enterprise platformAI-powered developer platformhttps://github.com/enterprise
GitHub Advanced SecurityEnterprise-grade security featureshttps://github.com/security/advanced-security
Copilot for BusinessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/premium-support
Pricinghttps://github.com/pricing
Search syntax tipshttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
documentationhttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
Sign in https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2Fchz07%2FLeetCode-SQL-Summary
Sign up https://patch-diff.githubusercontent.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E&source=header-repo&source_repo=chz07%2FLeetCode-SQL-Summary
Reloadhttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary
Reloadhttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary
Reloadhttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary
chz07 https://patch-diff.githubusercontent.com/chz07
LeetCode-SQL-Summaryhttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary
siqichen-usc/LeetCode-SQL-Summaryhttps://patch-diff.githubusercontent.com/siqichen-usc/LeetCode-SQL-Summary
Notifications https://patch-diff.githubusercontent.com/login?return_to=%2Fchz07%2FLeetCode-SQL-Summary
Fork 0 https://patch-diff.githubusercontent.com/login?return_to=%2Fchz07%2FLeetCode-SQL-Summary
Star 0 https://patch-diff.githubusercontent.com/login?return_to=%2Fchz07%2FLeetCode-SQL-Summary
0 stars https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/stargazers
132 forks https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/forks
Branches https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/branches
Tags https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/tags
Activity https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/activity
Star https://patch-diff.githubusercontent.com/login?return_to=%2Fchz07%2FLeetCode-SQL-Summary
Notifications https://patch-diff.githubusercontent.com/login?return_to=%2Fchz07%2FLeetCode-SQL-Summary
Code https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary
Pull requests 0 https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/pulls
Actions https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/actions
Projects 0 https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/projects
Security 0 https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/security
Insights https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/pulse
Code https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary
Pull requests https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/pulls
Actions https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/actions
Projects https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/projects
Security https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/security
Insights https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/pulse
Brancheshttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/branches
Tagshttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/tags
https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/branches
https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/tags
611 Commitshttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/commits/master/
https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/commits/master/
Basicshttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/tree/master/Basics
Basicshttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/tree/master/Basics
CASE-WHENhttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/tree/master/CASE-WHEN
CASE-WHENhttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/tree/master/CASE-WHEN
Joinhttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/tree/master/Join
Joinhttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/tree/master/Join
OFFSET-FETCHhttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/tree/master/OFFSET-FETCH
OFFSET-FETCHhttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/tree/master/OFFSET-FETCH
PIVOT-UNPIVOThttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/tree/master/PIVOT-UNPIVOT
PIVOT-UNPIVOThttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/tree/master/PIVOT-UNPIVOT
Questions_by_IDhttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/tree/master/Questions_by_ID
Questions_by_IDhttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/tree/master/Questions_by_ID
SQL-Commandhttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/tree/master/SQL-Command
SQL-Commandhttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/tree/master/SQL-Command
Subqueryhttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/tree/master/Subquery
Subqueryhttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/tree/master/Subquery
Variablehttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/tree/master/Variable
Variablehttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/tree/master/Variable
Window-Functionhttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/tree/master/Window-Function
Window-Functionhttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/tree/master/Window-Function
Readme.mdhttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Readme.md
Readme.mdhttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Readme.md
READMEhttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary
https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary#leetcode-sql-summary
https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary#intro
https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary#leetcode-sql-questions-by-topcis
https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary#basics
Duplicate Emailshttps://leetcode.com/problems/duplicate-emails/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Basics/182_Duplicate_Emails.sql
Game Play Analysis Ihttps://leetcode.com/problems/game-play-analysis-i/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Basics/511_Game_Play_Analysis_I.sql
Get Highest Answer Rate Questionhttps://leetcode.com/problems/get-highest-answer-rate-question/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Basics/578_Get_Highest_Answer_Rate_Question.sql
Find Customer Refereehttps://leetcode.com/problems/find-customer-referee/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Basics/584_Find_Customer_Referee.sql
Customer Placing the Largest Number of Ordershttps://leetcode.com/problems/customer-placing-the-largest-number-of-orders/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Basics/586_Customer_Placing_the_Largest_Number_of_Orders.sql
Big Countrieshttps://leetcode.com/problems/big-countries/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Basics/595_Big_Countries.sql
Classes More Than 5 Studentshttps://leetcode.com/problems/classes-more-than-5-students/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Basics/596_Classes_More_Than_5_Students.sql
Biggest Single Numberhttps://leetcode.com/problems/biggest-single-number/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Basics/619_Biggest_Single_Number.sql
Not Boring Movieshttps://leetcode.com/problems/not-boring-movies/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Basics/620_Not_Boring_Movies.sql
Actors and Directors Who Cooperated At Least Three Timeshttps://leetcode.com/problems/actors-and-directors-who-cooperated-at-least-three-times/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Basics/1050_Actors_and_Directors_Who_Cooperated_At_Least_Three_Times.sql
Product Sales Analysis IIhttps://leetcode.com/problems/product-sales-analysis-ii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Basics/1069_Product_Sales_Analysis_II.sql
Project Employees IIhttps://leetcode.com/problems/project-employees-ii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Basics/1076_Project_Employees_II.sql
Sales Analysis Ihttps://leetcode.com/problems/sales-analysis-i/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Basics/1082_Sales_Analysis_I.sql
User Activity for the Past 30 Days Ihttps://leetcode.com/problems/user-activity-for-the-past-30-days-i/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Basics/1141_User_Activity_for_the_Past_30_Days_I.sql
Article Views Ihttps://leetcode.com/problems/article-views-i/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Basics/1148_Article_Views_I.sql
Article Views IIhttps://leetcode.com/problems/article-views-ii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Basics/1149_Article_Views_II.sql
https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary#sql-command
Delete Duplicate Emailshttps://leetcode.com/problems/delete-duplicate-emails/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/SQL-Command/196_Delete_Duplicate_Emails.sql
Swap Salaryhttps://leetcode.com/problems/swap-salary/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/SQL-Command/627_Swap_Salary.sql
https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary#join
Combine Two Tableshttps://leetcode.com/problems/combine-two-tables/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/175_Combine_Two_Tables.sql
Employees Earning More Than Their Managershttps://leetcode.com/problems/employees-earning-more-than-their-managers/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/181_Employees_Earning_More_Than_Their_Managers.sql
Customers Who Never Orderhttps://leetcode.com/problems/customers-who-never-order/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/183_Customers_Who_Never_Order.sql
Department Highest Salaryhttps://leetcode.com/problems/department-highest-salary/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/184_Department_Highest_Salary.sql
Rising Temperaturehttps://leetcode.com/problems/rising-temperature/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/197_Rising_Temperature.sql
Trips and Usershttps://leetcode.com/problems/trips-and-users/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/262_Trips_and_Users.sql
Game Play Analysis IIhttps://leetcode.com/problems/game-play-analysis-ii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/512_Game_Play_Analysis_II.sql
Game Play Analysis IVhttps://leetcode.com/problems/game-play-analysis-iv/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/550_Game_Play_Analysis_IV.sql
Managers with at Least 5 Direct Reportshttps://leetcode.com/problems/managers-with-at-least-5-direct-reports/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/570_Managers_with_at_Least_5_Direct_Reports.sql
Winning Candidatehttps://leetcode.com/problems/winning-candidate/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/574_Winning_Candidate.sql
Employee Bonushttps://leetcode.com/problems/employee-bonus/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/577_Employee_Bonus.sql
Count Student Number in Departmentshttps://leetcode.com/problems/count-student-number-in-departments/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/580_Count_Student_Number_in_Departments.sql
Sales Personhttps://leetcode.com/problems/sales-person/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/607_Sales_Person.sql
Second Degree Followerhttps://leetcode.com/problems/second-degree-follower/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/614_Second_Degree_Follower.sql
Average Salary: Departments VS Companyhttps://leetcode.com/problems/average-salary-departments-vs-company/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/615_Average_Salary_Departments_VS_Company.sql
Product Sales Analysis Ihttps://leetcode.com/problems/product-sales-analysis-i/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/1068_Product_Sales_Analysis_I.sql
Product Sales Analysis IIIhttps://leetcode.com/problems/product-sales-analysis-iii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/1070_Product_Sales_Analysis_III.sql
Project Employees Ihttps://leetcode.com/problems/project-employees-i/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/1075_Project_Employees_I.sql
Project Employees IIhttps://leetcode.com/problems/project-employees-iii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/1077_Project_Employees_III.sql
Sales Analysis Ihttps://leetcode.com/problems/sales-analysis-ii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/1083_Sales_Analysis_II.sql
Highest Grade For Each Studenthttps://leetcode.com/problems/highest-grade-for-each-student/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/1112_Highest_Grade_For_Each_Student.sql
Reported Posts IIhttps://leetcode.com/problems/reported-posts-ii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/1132_Reported_Posts_II.sql
Market Analysis Ihttps://leetcode.com/problems/market-analysis-i/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/1158_Market_Analysis_I.sql
Product Price at a Given Datehttps://leetcode.com/problems/product-price-at-a-given-date/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/1164_Product_Price_at_a_Given_Date.sql
Last Person to Fit in the Elevatorhttps://leetcode.com/problems/last-person-to-fit-in-the-elevator/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/1204_Last_Person_to_Fit_in_the_Elevator.sql
Monthly Transactions IIhttps://leetcode.com/problems/monthly-transactions-ii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/1205_Monthly_Transactions_II.sql
Number of Comments per Posthttps://leetcode.com/problems/number-of-comments-per-post/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/1241_Number_of_Comments_per_Post.sql
All People Report to the Given Managerhttps://leetcode.com/problems/all-people-report-to-the-given-manager/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/1270_All_People_Report_to_the_Given_Manager.sql
Students and Examinationshttps://leetcode.com/problems/students-and-examinations/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/1280_Students_and_Examinations.sql
Weather Type in Each Countryhttps://leetcode.com/problems/weather-type-in-each-country/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/1294_Weather_Type_in_Each_Country.sql
Find the Team Sizehttps://leetcode.com/problems/find-the-team-size/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/1303_Find_the_Team_Size.sql
List the Products Ordered in a Periodhttps://leetcode.com/problems/list-the-products-ordered-in-a-period/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/1327_List_the_Products_Ordered_in_a_Period.sql
Number of Transactions per Visithttps://leetcode.com/problems/number-of-transactions-per-visit/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/1336_Number_of_Transactions_per_Visit.sql
Students With Invalid Departmentshttps://leetcode.com/problems/students-with-invalid-departments/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/1350_Students_With_Invalid_Departments.sql
Number of Trusted Contacts of a Customerhttps://leetcode.com/problems/number-of-trusted-contacts-of-a-customer/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/1364_Number_of_Trusted_Contacts_of_a_Customer.sql
Replace Employee ID With The Unique Identifierhttps://leetcode.com/problems/replace-employee-id-with-the-unique-identifier/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/1378_Replace_Employee_ID_With_The_Unique_Identifier.sql
Total Sales Amount by Yearhttps://leetcode.com/problems/total-sales-amount-by-year/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Simple-Join/1384_Total_Sales_Amount_by_Year.sql
Consecutive Numbershttps://leetcode.com/problems/consecutive-numbers/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Advanced-Join/180_Consecutive_Numbers.sql
Delete Duplicate Emailshttps://leetcode.com/problems/delete-duplicate-emails/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Advanced-Join/196_Delete_Duplicate_Emails.sql
Game Play Analysis IIIhttps://leetcode.com/problems/game-play-analysis-iii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Advanced-Join/534_Game_Play_Analysis_III.sql
Median Employee Salaryhttps://leetcode.com/problems/median-employee-salary/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Advanced-Join/569_Median_Employee_Salary.sql
Find Cumulative Salary of an Employeehttps://leetcode.com/problems/find-cumulative-salary-of-an-employee/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Advanced-Join/579_Find_Cumulative_Salary_of_an_Employee.sql
Human Traffic of Stadiumhttps://leetcode.com/problems/human-traffic-of-stadium/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Advanced-Join/601_Human_Traffic_of_Stadium.sql
Consecutive Available Seatshttps://leetcode.com/problems/consecutive-available-seats/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Advanced-Join/603_Consecutive_Available_Seats.sql
Shortest Distance in a Planehttps://leetcode.com/problems/shortest-distance-in-a-plane/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Advanced-Join/612_Shortest_Distance_in_a_Plane.sql
Shortest Distance in a Linehttps://leetcode.com/problems/shortest-distance-in-a-line/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Advanced-Join/613_Shortest_Distance_in_a_Line.sql
Game Play Analysis Vhttps://leetcode.com/problems/game-play-analysis-v/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Advanced-Join/1097_Game_Play_Analysis_V.sql
Active Businesseshttps://leetcode.com/problems/active-businesses/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Advanced-Join/1126_Active_Businesses.sql
User Purchase Platformhttps://leetcode.com/problems/user-purchase-platform/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Advanced-Join/1127_User_Purchase_Platform.sql
Market Analysis IIhttps://leetcode.com/problems/market-analysis-ii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Advanced-Join/1159_Market_Analysis_II.sql
Tournament Winnershttps://leetcode.com/problems/tournament-winners/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Advanced-Join/1194_Tournament_Winners.sql
Team Scores in Football Tournamenthttps://leetcode.com/problems/team-scores-in-football-tournament/submissions/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Advanced-Join/1212_Team_Scores_in_Football_Tournament.sql
Report Contiguous Dateshttps://leetcode.com/problems/report-contiguous-dates/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Advanced-Join/1225_Report_Contiguous_Dates.sql
Average Selling Pricehttps://leetcode.com/problems/average-selling-price/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Advanced-Join/1251_Average_Selling_Price.sql
Find the Start and End Number of Continuous Rangeshttps://leetcode.com/problems/find-the-start-and-end-number-of-continuous-ranges/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Advanced-Join/1285_Find_the_Start_and_End_Number_of_Continuous_Ranges.sql
Running Total for Different Gendershttps://leetcode.com/problems/running-total-for-different-genders/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Advanced-Join/1308_Running_Total_for_Different_Genders.sql
Restaurant Growthhttps://leetcode.com/problems/restaurant-growth/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Advanced-Join/1321_Restaurant_Growth.sql
Get the Second Most Recent Activityhttps://leetcode.com/problems/get-the-second-most-recent-activity/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Join/Advanced-Join/1369_Get_the_Second_Most_Recent_Activity.sql
https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary#subquery
Second Highest Salaryhttps://leetcode.com/problems/second-highest-salary/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/176_Second_Highest_Salary.sql
Customers Who Never Orderhttps://leetcode.com/problems/customers-who-never-order/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/183_Customers_Who_Never_Order.sql
Department Highest Salaryhttps://leetcode.com/problems/department-highest-salary/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/184_Department_Highest_Salary.sql
Delete Duplicate Emailshttps://leetcode.com/problems/delete-duplicate-emails/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/196_Delete_Duplicate_Emails.sql
Rising Temperaturehttps://leetcode.com/problems/rising-temperature/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/197_Rising_Temperature.sql
Game Play Analysis IIhttps://leetcode.com/problems/game-play-analysis-ii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/512_Game_Play_Analysis_II.sql
Median Employee Salaryhttps://leetcode.com/problems/median-employee-salary/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/569_Median_Employee_Salary.sql
Managers with at Least 5 Direct Reportshttps://leetcode.com/problems/managers-with-at-least-5-direct-reports/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/570_Managers_with_at_Least_5_Direct_Reports.sql
Find Median Given Frequency of Numbershttps://leetcode.com/problems/find-median-given-frequency-of-numbers/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/571_Find_Median_Given_Frequency_of_Numbers.sql
Winning Candidatehttps://leetcode.com/problems/winning-candidate/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/574_Winning_Candidate.sql
Find Cumulative Salary of an Employeehttps://leetcode.com/problems/find-cumulative-salary-of-an-employee/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/579_Find_Cumulative_Salary_of_an_Employee.sql
Count Student Number in Departmentshttps://leetcode.com/problems/count-student-number-in-departments/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/580_Count_Student_Number_in_Departments.sql
Friend Requests II: Who Has the Most Friendshttps://leetcode.com/problems/friend-requests-ii-who-has-the-most-friends/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/602_Friend_Requests_II_Who_Has_the_Most_Friends.sql
Consecutive Available Seatshttps://leetcode.com/problems/consecutive-available-seats/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/603_Consecutive_Available_Seats.sql
Sales Personhttps://leetcode.com/problems/sales-person/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/607_Sales_Person.sql
Tree Nodehttps://leetcode.com/problems/tree-node/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-SubqueryD/608_Tree_Node.sql
Shortest Distance in a Linehttps://leetcode.com/problems/shortest-distance-in-a-line/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/613_Shortest_Distance_in_a_Line.sql
Second Degree Followerhttps://leetcode.com/problems/second-degree-follower/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/614_Second_Degree_Follower.sql
Average Salary: Departments VS Companyhttps://leetcode.com/problems/average-salary-departments-vs-company/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/615_Average_Salary_Departments_VS_Company.sql
Students Report By Geographyhttps://leetcode.com/problems/students-report-by-geography/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/618_Students_Report_By_Geography.sql
Exchange Seatshttps://leetcode.com/problems/exchange-seats/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/626_Exchange_Seats.sql
Customers Who Bought All Productshttps://leetcode.com/problems/customers-who-bought-all-products/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/1045_Customers_Who_Bought_All_Products.sql
Product Sales Analysis IIIhttps://leetcode.com/problems/product-sales-analysis-iii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/1070_Product_Sales_Analysis_III.sql
Sales Analysis Ihttps://leetcode.com/problems/sales-analysis-ii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/1083_Sales_Analysis_II.sql
Sales Analysis Ihttps://leetcode.com/problems/sales-analysis-iii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/1084_Sales_Analysis_III.sql
Game Play Analysis Vhttps://leetcode.com/problems/game-play-analysis-v/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/1097_Game_Play_Analysis_V.sql
Unpopular Bookshttps://leetcode.com/problems/unpopular-books/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/1098_Unpopular_Books.sql
New Users Daily Counthttps://leetcode.com/problems/new-users-daily-count/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/1107_New_Users_Daily_Count.sql
Highest Grade For Each Studenthttps://leetcode.com/problems/highest-grade-for-each-student/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/1112_Highest_Grade_For_Each_Student.sql
Active Businesseshttps://leetcode.com/problems/active-businesses/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/1126_Active_Businesses.sql
Reported Posts IIhttps://leetcode.com/problems/reported-posts-ii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/1132_Reported_Posts_II.sql
User Activity for the Past 30 Days IIhttps://leetcode.com/problems/user-activity-for-the-past-30-days-ii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/1142_User_Activity_for_the_Past_30_Days_II.sql
Market Analysis Ihttps://leetcode.com/problems/market-analysis-i/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/1158_Market_Analysis_I.sql
Immediate Food Delivery IIhttps://leetcode.com/problems/immediate-food-delivery-ii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/1174_Immediate_Food_Delivery_II.sql
Last Person to Fit in the Elevatorhttps://leetcode.com/problems/last-person-to-fit-in-the-elevator/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/1204_Last_Person_to_Fit_in_the_Elevator.sql
Report Contiguous Dateshttps://leetcode.com/problems/report-contiguous-dates/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/1225_Report_Contiguous_Dates.sql
Page Recommendationshttps://leetcode.com/problems/page-recommendations/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/1264_Page_Recommendations.sql
Students and Examinationshttps://leetcode.com/problems/students-and-examinations/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/1280_Students_and_Examinations.sql
Find the Start and End Number of Continuous Rangeshttps://leetcode.com/problems/find-the-start-and-end-number-of-continuous-ranges/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/1285_Find_the_Start_and_End_Number_of_Continuous_Ranges.sql
Weather Type in Each Countryhttps://leetcode.com/problems/weather-type-in-each-country/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/1294_Weather_Type_in_Each_Country.sql
Restaurant Growthhttps://leetcode.com/problems/restaurant-growth/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/1321_Restaurant_Growth.sql
Ads Performancehttps://leetcode.com/problems/ads-performance/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/1322_Ads_Performance.sql
Number of Transactions per Visithttps://leetcode.com/problems/number-of-transactions-per-visit/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/1336_Number_of_Transactions_per_Visit.sql
Movie Ratinghttps://leetcode.com/problems/movie-rating/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/1341_Movie_Rating.sql
Students With Invalid Departmentshttps://leetcode.com/problems/students-with-invalid-departments/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/1350_Students_With_Invalid_Departments.sql
Activity Participantshttps://leetcode.com/problems/activity-participants/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/1355_Activity_Participants.sql
Number of Trusted Contacts of a Customerhttps://leetcode.com/problems/number-of-trusted-contacts-of-a-customer/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/1364_Number_of_Trusted_Contacts_of_a_Customer.sql
Get the Second Most Recent Activityhttps://leetcode.com/problems/get-the-second-most-recent-activity/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Simple-Subquery/1369_Get_the_Second_Most_Recent_Activity.sql
Trips and Usershttps://leetcode.com/problems/trips-and-users/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Advanced-Subquery/262_Trips_and_Users.sql
Game Play Analysis IVhttps://leetcode.com/problems/game-play-analysis-iv/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Advanced-Subquery/550_Game_Play_Analysis_IV.sql
Median Employee Salaryhttps://leetcode.com/problems/median-employee-salary/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Advanced-Subquery/569_Median_Employee_Salary.sql
Investments in 2016https://leetcode.com/problems/investments-in-2016/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Advanced-Subquery/585_Investments_in_2016.sql
Friend Requests I: Overall Acceptance Ratehttps://leetcode.com/problems/friend-requests-i-overall-acceptance-rate/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Advanced-Subquery/597_Friend_Requests_I_Overall_Acceptance_Rate.sql
Human Traffic of Stadiumhttps://leetcode.com/problems/human-traffic-of-stadium/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Advanced-Subquery/601_Human_Traffic_of_Stadium.sql
Project Employees IIhttps://leetcode.com/problems/project-employees-iii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Advanced-Subquery/1077_Project_Employees_III.sql
User Purchase Platformhttps://leetcode.com/problems/user-purchase-platform/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Advanced-Subquery/1127_User_Purchase_Platform.sql
Market Analysis IIhttps://leetcode.com/problems/market-analysis-ii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Advanced-Subquery/1159_Market_Analysis_II.sql
Product Price at a Given Datehttps://leetcode.com/problems/product-price-at-a-given-date/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Advanced-Subquery/1164_Product_Price_at_a_Given_Date.sql
Tournament Winnershttps://leetcode.com/problems/tournament-winners/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Advanced-Subquery/1194_Tournament_Winners.sql
Monthly Transactions IIhttps://leetcode.com/problems/monthly-transactions-ii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Advanced-Subquery/1205_Monthly_Transactions_II.sql
All People Report to the Given Managerhttps://leetcode.com/problems/all-people-report-to-the-given-manager/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Advanced-Subquery/1270_All_People_Report_to_the_Given_Manager.sql
Customers Who Bought Products A and B but Not Chttps://leetcode.com/problems/customers-who-bought-products-a-and-b-but-not-c/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Advanced-Subquery/1398_Customers_Who_Bought_Products_A_and_B_but_Not_C.sql
All People Report to the Given Managerhttps://leetcode.com/problems/all-people-report-to-the-given-manager/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Recursive-CTE/1270_All_People_Report_to_the_Given_Manager.sql
Number of Transactions per Visithttps://leetcode.com/problems/number-of-transactions-per-visit/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Recursive-CTE/1336_Number_of_Transactions_per_Visit.sql
Total Sales Amount by Yearhttps://leetcode.com/problems/total-sales-amount-by-year/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Subquery/Recursive-CTE/1384_Total_Sales_Amount_by_Year.sql
https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary#window-function
Second Highest Salaryhttps://leetcode.com/problems/second-highest-salary/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/176_Second_Highest_Salary.sql
Nth Highest Salaryhttps://leetcode.com/problems/nth-highest-salary/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/177_Nth_Highest_Salary.sql
Rank Scoreshttps://leetcode.com/problems/rank-scores/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/178_Rank_Scores.sql
Consecutive Numbershttps://leetcode.com/problems/consecutive-numbers/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/180_Consecutive_Numbers.sql
Department Highest Salaryhttps://leetcode.com/problems/department-highest-salary/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/184_Department_Highest_Salary.sql
Department Top Three Salarieshttps://leetcode.com/problems/department-top-three-salaries/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/185_Department_Top_Three_Salaries.sql
Rising Temperaturehttps://leetcode.com/problems/rising-temperature/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/197_Rising_Temperature.sql
Game Play Analysis IIhttps://leetcode.com/problems/game-play-analysis-ii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/512_Game_Play_Analysis_II.sql
Game Play Analysis IIIhttps://leetcode.com/problems/game-play-analysis-iii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/534_Game_Play_Analysis_III.sql
Game Play Analysis IVhttps://leetcode.com/problems/game-play-analysis-iv/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/550_Game_Play_Analysis_IV.sql
Median Employee Salaryhttps://leetcode.com/problems/median-employee-salary/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/569_Median_Employee_Salary.sql
Find Median Given Frequency of Numbershttps://leetcode.com/problems/find-median-given-frequency-of-numbers/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/571_Find_Median_Given_Frequency_of_Numbers.sql
Find Cumulative Salary of an Employeehttps://leetcode.com/problems/find-cumulative-salary-of-an-employee/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/579_Find_Cumulative_Salary_of_an_Employee.sql
Investments in 2016https://leetcode.com/problems/investments-in-2016/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/585_Investments_in_2016.sql
Human Traffic of Stadiumhttps://leetcode.com/problems/human-traffic-of-stadium/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/601_Human_Traffic_of_Stadium.sql
Consecutive Available Seatshttps://leetcode.com/problems/consecutive-available-seats/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/603_Consecutive_Available_Seats.sql
Shortest Distance in a Linehttps://leetcode.com/problems/shortest-distance-in-a-line/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/613_Shortest_Distance_in_a_Line.sql
Average Salary: Departments VS Companyhttps://leetcode.com/problems/average-salary-departments-vs-company/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/615_Average_Salary_Departments_VS_Company.sql
Students Report By Geographyhttps://leetcode.com/problems/students-report-by-geography/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/618_Students_Report_By_Geography.sql
Product Sales Analysis IIIhttps://leetcode.com/problems/product-sales-analysis-iii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/1070_Product_Sales_Analysis_III.sql
Project Employees IIhttps://leetcode.com/problems/project-employees-iii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/1077_Project_Employees_III.sql
New Users Daily Counthttps://leetcode.com/problems/new-users-daily-count/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/1107_New_Users_Daily_Count.sql
Highest Grade For Each Studenthttps://leetcode.com/problems/highest-grade-for-each-student/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/1112_Highest_Grade_For_Each_Student.sql
Active Businesseshttps://leetcode.com/problems/active-businesses/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/1126_Active_Businesses.sql
User Purchase Platformhttps://leetcode.com/problems/user-purchase-platform/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/1127_User_Purchase_Platform.sql
Market Analysis IIhttps://leetcode.com/problems/market-analysis-ii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/1159_Market_Analysis_II.sql
Product Price at a Given Datehttps://leetcode.com/problems/product-price-at-a-given-date/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/1164_Product_Price_at_a_Given_Date.sql
Immediate Food Delivery IIhttps://leetcode.com/problems/immediate-food-delivery-ii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/1174_Immediate_Food_Delivery_II.sql
Tournament Winnershttps://leetcode.com/problems/tournament-winners/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/1194_Tournament_Winners.sql
Last Person to Fit in the Elevatorhttps://leetcode.com/problems/last-person-to-fit-in-the-elevator/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/1204_Last_Person_to_Fit_in_the_Elevator.sql
Report Contiguous Dateshttps://leetcode.com/problems/report-contiguous-dates/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/1225_Report_Contiguous_Dates.sql
Find the Start and End Number of Continuous Rangeshttps://leetcode.com/problems/find-the-start-and-end-number-of-continuous-ranges/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/1285_Find_the_Start_and_End_Number_of_Continuous_Ranges.sql
Find the Team Sizehttps://leetcode.com/problems/find-the-team-size/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/1303_Find_the_Team_Size.sql
Running Total for Different Gendershttps://leetcode.com/problems/running-total-for-different-genders/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/1308_Running_Total_for_Different_Genders.sql
Restaurant Growthhttps://leetcode.com/problems/restaurant-growth/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/1321_Restaurant_Growth.sql
Activity Participantshttps://leetcode.com/problems/activity-participants/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/1355_Activity_Participants.sql
Get the Second Most Recent Activityhttps://leetcode.com/problems/get-the-second-most-recent-activity/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Window-Function/1369_Get_the_Second_Most_Recent_Activity.sql
https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary#case-when-or-iif
Trips and Usershttps://leetcode.com/problems/trips-and-users/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/CASE-WHEN/262_Trips_and_Users.sql
Friend Requests I: Overall Acceptance Ratehttps://leetcode.com/problems/friend-requests-i-overall-acceptance-rate/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/CASE-WHEN/597_Friend_Requests_I_Overall_Acceptance_Rate.sql
Tree Nodehttps://leetcode.com/problems/tree-node/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/CASE-WHEN/608_Tree_Node.sql
Triangle Judgementhttps://leetcode.com/problems/triangle-judgement/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/CASE-WHEN/610_Triangle_Judgement.sql
Average Salary: Departments VS Companyhttps://leetcode.com/problems/average-salary-departments-vs-company/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/CASE-WHEN/615_Average_Salary_Departments_VS_Company.sql
Students Report By Geographyhttps://leetcode.com/problems/students-report-by-geography/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/CASE-WHEN/618_Students_Report_By_Geography.sql
Exchange Seatshttps://leetcode.com/problems/exchange-seats/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/CASE-WHEN/626_Exchange_Seats.sql
Swap Salaryhttps://leetcode.com/problems/swap-salary/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/CASE-WHEN/627_Swap_Salary.sql
Active Businesseshttps://leetcode.com/problems/active-businesses/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/CASE-WHEN/1126_Active_Businesses.sql
User Activity for the Past 30 Days IIhttps://leetcode.com/problems/user-activity-for-the-past-30-days-ii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/CASE-WHEN/1142_User_Activity_for_the_Past_30_Days_II.sql
Market Analysis Ihttps://leetcode.com/problems/market-analysis-i/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/CASE-WHEN/1158_Market_Analysis_I.sql
Market Analysis IIhttps://leetcode.com/problems/market-analysis-ii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/CASE-WHEN/1159_Market_Analysis_II.sql
Immediate Food Delivery Ihttps://leetcode.com/problems/immediate-food-delivery-i/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/CASE-WHEN/1173_Immediate_Food_Delivery_I.sql
Immediate Food Delivery IIhttps://leetcode.com/problems/immediate-food-delivery-ii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/CASE-WHEN/1174_Immediate_Food_Delivery_II.sql
Monthly Transactions Ihttps://leetcode.com/problems/monthly-transactions-i/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/CASE-WHEN/1193_Monthly_Transactions_I.sql
Tournament Winnershttps://leetcode.com/problems/tournament-winners/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/CASE-WHEN/1194_Tournament_Winners.sql
Queries Quality and Percentagehttps://leetcode.com/problems/queries-quality-and-percentage/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/CASE-WHEN/1211_Queries_Quality_and_Percentage.sql
Team Scores in Football Tournamenthttps://leetcode.com/problems/team-scores-in-football-tournament/submissions/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/CASE-WHEN/1212_Team_Scores_in_Football_Tournament.sql
Page Recommendationshttps://leetcode.com/problems/page-recommendations/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/CASE-WHEN/1264_Page_Recommendations.sql
Weather Type in Each Countryhttps://leetcode.com/problems/weather-type-in-each-country/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/CASE-WHEN/1294_Weather_Type_in_Each_Country.sql
Ads Performancehttps://leetcode.com/problems/ads-performance/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/CASE-WHEN/1322_Ads_Performance.sql
Capital Gain/Losshttps://leetcode.com/problems/capital-gainloss/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/CASE-WHEN/1393_Capital_Gain_Loss.sql
Customers Who Bought Products A and B but Not Chttps://leetcode.com/problems/customers-who-bought-products-a-and-b-but-not-c/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/CASE-WHEN/1398_Customers_Who_Bought_Products_A_and_B_but_Not_C.sql
https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary#offset-fetch
Second Highest Salaryhttps://leetcode.com/problems/second-highest-salary/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/blob/master/OFFSET-FETCH/176_Second_Highest_Salary.sql
Nth Highest Salaryhttps://leetcode.com/problems/nth-highest-salary/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/OFFSET-FETCH/177_Nth_Highest_Salary.sql
Restaurant Growthhttps://leetcode.com/problems/restaurant-growth/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/OFFSET-FETCH/1321_Restaurant_Growth.sql
https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary#pivot--unpivot
Friend Requests II: Who Has the Most Friendshttps://leetcode.com/problems/friend-requests-ii-who-has-the-most-friends/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/PIVOT-UNPIVOT/602_Friend_Requests_II_Who_Has_the_Most_Friends.sql
Students Report By Geographyhttps://leetcode.com/problems/students-report-by-geography/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/PIVOT-UNPIVOT/618_Students_Report_By_Geography.sql
Reformat Department Tablehttps://leetcode.com/problems/reformat-department-table/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/PIVOT-UNPIVOT/1179_Reformat_Department_Table.sql
Ads Performancehttps://leetcode.com/problems/ads-performance/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/PIVOT-UNPIVOT/1322_Ads_Performance.sql
https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary#variable
Friend Requests I: Overall Acceptance Ratehttps://leetcode.com/problems/friend-requests-i-overall-acceptance-rate/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Variable/597_Friend_Requests_I_Overall_Acceptance_Rate.sql
Unpopular Bookshttps://leetcode.com/problems/unpopular-books/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Variable/1098_Unpopular_Books.sql
New Users Daily Counthttps://leetcode.com/problems/new-users-daily-count/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Variable/1107_New_Users_Daily_Count.sql
Reported Postshttps://leetcode.com/problems/reported-posts/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Variable/1113_Reported_Posts.sql
https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary#leetcode-sql-questions-by-id
Combine Two Tableshttps://leetcode.com/problems/combine-two-tables/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/175_Combine_Two_Tables.sql
Second Highest Salaryhttps://leetcode.com/problems/second-highest-salary/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/176_Second_Highest_Salary.sql
Nth Highest Salaryhttps://leetcode.com/problems/nth-highest-salary/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/177_Nth_Highest_Salary.sql
Rank Scoreshttps://leetcode.com/problems/rank-scores/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/178_Rank_Scores.sql
Consecutive Numbershttps://leetcode.com/problems/consecutive-numbers/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/180_Consecutive_Numbers.sql
Employees Earning More Than Their Managershttps://leetcode.com/problems/employees-earning-more-than-their-managers/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/181_Employees_Earning_More_Than_Their_Managers.sql
Duplicate Emailshttps://leetcode.com/problems/duplicate-emails/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/182_Duplicate_Emails.sql
Customers Who Never Orderhttps://leetcode.com/problems/customers-who-never-order/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/183_Customers_Who_Never_Order.sql
Department Highest Salaryhttps://leetcode.com/problems/department-highest-salary/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/184_Department_Highest_Salary.sql
Department Top Three Salarieshttps://leetcode.com/problems/department-top-three-salaries/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/185_Department_Top_Three_Salaries.sql
Delete Duplicate Emailshttps://leetcode.com/problems/delete-duplicate-emails/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/196_Delete_Duplicate_Emails.sql
Rising Temperaturehttps://leetcode.com/problems/rising-temperature/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/197_Rising_Temperature.sql
Trips and Usershttps://leetcode.com/problems/trips-and-users/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/262_Trips_and_Users.sql
Game Play Analysis Ihttps://leetcode.com/problems/game-play-analysis-i/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/511_Game_Play_Analysis_I.sql
Game Play Analysis IIhttps://leetcode.com/problems/game-play-analysis-ii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/512_Game_Play_Analysis_II.sql
Game Play Analysis IIIhttps://leetcode.com/problems/game-play-analysis-iii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/534_Game_Play_Analysis_III.sql
Game Play Analysis IVhttps://leetcode.com/problems/game-play-analysis-iv/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/550_Game_Play_Analysis_IV.sql
Median Employee Salaryhttps://leetcode.com/problems/median-employee-salary/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/569_Median_Employee_Salary.sql
Managers with at Least 5 Direct Reportshttps://leetcode.com/problems/managers-with-at-least-5-direct-reports/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/570_Managers_with_at_Least_5_Direct_Reports.sql
Find Median Given Frequency of Numbershttps://leetcode.com/problems/find-median-given-frequency-of-numbers/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/571_Find_Median_Given_Frequency_of_Numbers.sql
Winning Candidatehttps://leetcode.com/problems/winning-candidate/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/574_Winning_Candidate.sql
Employee Bonushttps://leetcode.com/problems/employee-bonus/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/577_Employee_Bonus.sql
Get Highest Answer Rate Questionhttps://leetcode.com/problems/get-highest-answer-rate-question/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/578_Get_Highest_Answer_Rate_Question.sql
Find Cumulative Salary of an Employeehttps://leetcode.com/problems/find-cumulative-salary-of-an-employee/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/579_Find_Cumulative_Salary_of_an_Employee.sql
Count Student Number in Departmentshttps://leetcode.com/problems/count-student-number-in-departments/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/580_Count_Student_Number_in_Departments.sql
Find Customer Refereehttps://leetcode.com/problems/find-customer-referee/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/584_Find_Customer_Referee.sql
Investments in 2016https://leetcode.com/problems/investments-in-2016/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/585_Investments_in_2016.sql
Customer Placing the Largest Number of Ordershttps://leetcode.com/problems/customer-placing-the-largest-number-of-orders/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/586_Customer_Placing_the_Largest_Number_of_Orders.sql
Big Countrieshttps://leetcode.com/problems/big-countries/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/595_Big_Countries.sql
Classes More Than 5 Studentshttps://leetcode.com/problems/classes-more-than-5-students/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/596_Classes_More_Than_5_Students.sql
Friend Requests I: Overall Acceptance Ratehttps://leetcode.com/problems/friend-requests-i-overall-acceptance-rate/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/597_Friend_Requests_I_Overall_Acceptance_Rate.sql
Human Traffic of Stadiumhttps://leetcode.com/problems/human-traffic-of-stadium/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/601_Human_Traffic_of_Stadium.sql
Friend Requests II: Who Has the Most Friendshttps://leetcode.com/problems/friend-requests-ii-who-has-the-most-friends/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/602_Friend_Requests_II_Who_Has_the_Most_Friends.sql
Consecutive Available Seatshttps://leetcode.com/problems/consecutive-available-seats/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/603_Consecutive_Available_Seats.sql
Sales Personhttps://leetcode.com/problems/sales-person/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/607_Sales_Person.sql
Tree Nodehttps://leetcode.com/problems/tree-node/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/608_Tree_Node.sql
Triangle Judgementhttps://leetcode.com/problems/triangle-judgement/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/610_Triangle_Judgement.sql
Shortest Distance in a Planehttps://leetcode.com/problems/shortest-distance-in-a-plane/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/612_Shortest_Distance_in_a_Plane.sql
Shortest Distance in a Linehttps://leetcode.com/problems/shortest-distance-in-a-line/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/613_Shortest_Distance_in_a_Line.sql
Second Degree Followerhttps://leetcode.com/problems/second-degree-follower/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/614_Second_Degree_Follower.sql
Average Salary: Departments VS Companyhttps://leetcode.com/problems/average-salary-departments-vs-company/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/615_Average_Salary_Departments_VS_Company.sql
Students Report By Geographyhttps://leetcode.com/problems/students-report-by-geography/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/618_Students_Report_By_Geography.sql
Biggest Single Numberhttps://leetcode.com/problems/biggest-single-number/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/619_Biggest_Single_Number.sql
Not Boring Movieshttps://leetcode.com/problems/not-boring-movies/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/620_Not_Boring_Movies.sql
Exchange Seatshttps://leetcode.com/problems/exchange-seats/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/626_Exchange_Seats.sql
Swap Salaryhttps://leetcode.com/problems/swap-salary/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/627_Swap_Salary.sql
Customers Who Bought All Productshttps://leetcode.com/problems/customers-who-bought-all-products/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1045_Customers_Who_Bought_All_Products.sql
Actors and Directors Who Cooperated At Least Three Timeshttps://leetcode.com/problems/actors-and-directors-who-cooperated-at-least-three-times/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1050_Actors_and_Directors_Who_Cooperated_At_Least_Three_Times.sql
Product Sales Analysis Ihttps://leetcode.com/problems/product-sales-analysis-i/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1068_Product_Sales_Analysis_I.sql
Product Sales Analysis IIhttps://leetcode.com/problems/product-sales-analysis-ii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1069_Product_Sales_Analysis_II.sql
Product Sales Analysis IIIhttps://leetcode.com/problems/product-sales-analysis-iii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1070_Product_Sales_Analysis_III.sql
Project Employees Ihttps://leetcode.com/problems/project-employees-i/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1075_Project_Employees_I.sql
Project Employees IIhttps://leetcode.com/problems/project-employees-ii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1076_Project_Employees_II.sql
Project Employees IIhttps://leetcode.com/problems/project-employees-iii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1077_Project_Employees_III.sql
Sales Analysis Ihttps://leetcode.com/problems/sales-analysis-i/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1082_Sales_Analysis_I.sql
Sales Analysis Ihttps://leetcode.com/problems/sales-analysis-ii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1083_Sales_Analysis_II.sql
Sales Analysis Ihttps://leetcode.com/problems/sales-analysis-iii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1084_Sales_Analysis_III.sql
Sales Analysis Ihttps://leetcode.com/problems/sales-analysis-iii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1084_Sales_Analysis_III.sql
Game Play Analysis Vhttps://leetcode.com/problems/game-play-analysis-v/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1097_Game_Play_Analysis_V.sql
Unpopular Bookshttps://leetcode.com/problems/unpopular-books/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1098_Unpopular_Books.sql
New Users Daily Counthttps://leetcode.com/problems/new-users-daily-count/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1107_New_Users_Daily_Count.sql
Highest Grade For Each Studenthttps://leetcode.com/problems/highest-grade-for-each-student/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1112_Highest_Grade_For_Each_Student.sql
Reported Postshttps://leetcode.com/problems/reported-posts/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1113_Reported_Posts.sql
Active Businesseshttps://leetcode.com/problems/active-businesses/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1126_Active_Businesses.sql
User Purchase Platformhttps://leetcode.com/problems/user-purchase-platform/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1127_User_Purchase_Platform.sql
Reported Posts IIhttps://leetcode.com/problems/reported-posts-ii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1132_Reported_Posts_II.sql
User Activity for the Past 30 Days Ihttps://leetcode.com/problems/user-activity-for-the-past-30-days-i/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1141_User_Activity_for_the_Past_30_Days_I.sql
User Activity for the Past 30 Days IIhttps://leetcode.com/problems/user-activity-for-the-past-30-days-ii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1142_User_Activity_for_the_Past_30_Days_II.sql
Article Views Ihttps://leetcode.com/problems/article-views-i/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1148_Article_Views_I.sql
Article Views IIhttps://leetcode.com/problems/article-views-ii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1149_Article_Views_II.sql
Market Analysis Ihttps://leetcode.com/problems/market-analysis-i/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1158_Market_Analysis_I.sql
Market Analysis IIhttps://leetcode.com/problems/market-analysis-ii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1159_Market_Analysis_II.sql
Product Price at a Given Datehttps://leetcode.com/problems/product-price-at-a-given-date/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1164_Product_Price_at_a_Given_Date.sql
Immediate Food Delivery Ihttps://leetcode.com/problems/immediate-food-delivery-i/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1173_Immediate_Food_Delivery_I.sql
Immediate Food Delivery IIhttps://leetcode.com/problems/immediate-food-delivery-ii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1174_Immediate_Food_Delivery_II.sql
Reformat Department Tablehttps://leetcode.com/problems/reformat-department-table/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1179_Reformat_Department_Table.sql
Monthly Transactions Ihttps://leetcode.com/problems/monthly-transactions-i/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1193_Monthly_Transactions_I.sql
Tournament Winnershttps://leetcode.com/problems/tournament-winners/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1194_Tournament_Winners.sql
Last Person to Fit in the Elevatorhttps://leetcode.com/problems/last-person-to-fit-in-the-elevator/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1204_Last_Person_to_Fit_in_the_Elevator.sql
Monthly Transactions IIhttps://leetcode.com/problems/monthly-transactions-ii/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1205_Monthly_Transactions_II.sql
Queries Quality and Percentagehttps://leetcode.com/problems/queries-quality-and-percentage/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1211_Queries_Quality_and_Percentage.sql
Team Scores in Football Tournamenthttps://leetcode.com/problems/team-scores-in-football-tournament/submissions/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1212_Team_Scores_in_Football_Tournament.sql
Report Contiguous Dateshttps://leetcode.com/problems/report-contiguous-dates/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1225_Report_Contiguous_Dates.sql
Number of Comments per Posthttps://leetcode.com/problems/number-of-comments-per-post/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1241_Number_of_Comments_per_Post.sql
Average Selling Pricehttps://leetcode.com/problems/average-selling-price/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1251_Average_Selling_Price.sql
Page Recommendationshttps://leetcode.com/problems/page-recommendations/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1264_Page_Recommendations.sql
All People Report to the Given Managerhttps://leetcode.com/problems/all-people-report-to-the-given-manager/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1270_All_People_Report_to_the_Given_Manager.sql
Students and Examinationshttps://leetcode.com/problems/students-and-examinations/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1280_Students_and_Examinations.sql
Find the Start and End Number of Continuous Rangeshttps://leetcode.com/problems/find-the-start-and-end-number-of-continuous-ranges/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1285_Find_the_Start_and_End_Number_of_Continuous_Ranges.sql
Weather Type in Each Countryhttps://leetcode.com/problems/weather-type-in-each-country/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1294_Weather_Type_in_Each_Country.sql
Find the Team Sizehttps://leetcode.com/problems/find-the-team-size/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1303_Find_the_Team_Size.sql
Running Total for Different Gendershttps://leetcode.com/problems/running-total-for-different-genders/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1308_Running_Total_for_Different_Genders.sql
Restaurant Growthhttps://leetcode.com/problems/restaurant-growth/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1321_Restaurant_Growth.sql
Ads Performancehttps://leetcode.com/problems/ads-performance/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1322_Ads_Performance.sql
List the Products Ordered in a Periodhttps://leetcode.com/problems/list-the-products-ordered-in-a-period/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1327_List_the_Products_Ordered_in_a_Period.sql
Number of Transactions per Visithttps://leetcode.com/problems/number-of-transactions-per-visit/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1336_Number_of_Transactions_per_Visit.sql
Movie Ratinghttps://leetcode.com/problems/movie-rating/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1341_Movie_Rating.sql
Students With Invalid Departmentshttps://leetcode.com/problems/students-with-invalid-departments/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1350_Students_With_Invalid_Departments.sql
Activity Participantshttps://leetcode.com/problems/activity-participants/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1355_Activity_Participants.sql
Number of Trusted Contacts of a Customerhttps://leetcode.com/problems/number-of-trusted-contacts-of-a-customer/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1364_Number_of_Trusted_Contacts_of_a_Customer.sql
Get the Second Most Recent Activityhttps://leetcode.com/problems/get-the-second-most-recent-activity/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1369_Get_the_Second_Most_Recent_Activity.sql
Replace Employee ID With The Unique Identifierhttps://leetcode.com/problems/replace-employee-id-with-the-unique-identifier/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1378_Replace_Employee_ID_With_The_Unique_Identifier.sql
Total Sales Amount by Yearhttps://leetcode.com/problems/total-sales-amount-by-year/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1384_Total_Sales_Amount_by_Year.sql
Capital Gain/Losshttps://leetcode.com/problems/capital-gainloss/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1393_Capital_Gain_Loss.sql
Customers Who Bought Products A and B but Not Chttps://leetcode.com/problems/customers-who-bought-products-a-and-b-but-not-c/
Soln.https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/blob/master/Questions_by_ID/1398_Customers_Who_Bought_Products_A_and_B_but_Not_C.sql
Readme https://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary#readme-ov-file
Please reload this pagehttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary
Activityhttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/activity
0 starshttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/stargazers
0 watchinghttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/watchers
0 forkshttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/forks
Report repository https://patch-diff.githubusercontent.com/contact/report-content?content_url=https%3A%2F%2Fgithub.com%2Fchz07%2FLeetCode-SQL-Summary&report=chz07+%28user%29
Releaseshttps://patch-diff.githubusercontent.com/chz07/LeetCode-SQL-Summary/releases
Packages 0https://patch-diff.githubusercontent.com/users/chz07/packages?repo_name=LeetCode-SQL-Summary
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width

URLs of crawlers that visited me.