Files

Basics
CASE-WHEN
Join
OFFSET-FETCH
PIVOT-UNPIVOT
Questions_by_ID
SQL-Command
Subquery
- Advanced-Subquery
- Recursive-CTE
- Simple-Subquery
  - 1045_Customers_Who_Bought_All_Products.sql
  - 1070_Product_Sales_Analysis_III.sql
  - 1083_Sales_Analysis_II.sql
  - 1084_Sales_Analysis_III.sql
  - 1097_Game_Play_Analysis_V.sql
  - 1098_Unpopular_Books.sql
  - 1107_New_Users_Daily_Count.sql
  - 1112_Highest_Grade_For_Each_Student.sql
  - 1126_Active_Businesses.sql
  - 1132_Reported_Posts_II.sql
  - 1142_User_Activity_for_the_Past_30_Days_II.sql
  - 1158_Market_Analysis_I.sql
  - 1174_Immediate_Food_Delivery_II.sql
  - 1204_Last_Person_to_Fit_in_the_Elevator.sql
  - 1225_Report_Contiguous_Dates.sql
  - 1264_Page_Recommendations.sql
  - 1280_Students_and_Examinations.sql
  - 1285_Find_the_Start_and_End_Number_of_Continuous_Ranges.sql
  - 1294_Weather_Type_in_Each_Country.sql
  - 1321_Restaurant_Growth.sql
  - 1322_Ads_Performance.sql
  - 1336_Number_of_Transactions_per_Visit.sql
  - 1341_Movie_Rating.sql
  - 1350_Students_With_Invalid_Departments.sql
  - 1355_Activity_Participants.sql
  - 1364_Number_of_Trusted_Contacts_of_a_Customer.sql
  - 1369_Get_the_Second_Most_Recent_Activity.sql
  - 176_Second_Highest_Salary.sql
  - 183_Customers_Who_Never_Order.sql
  - 184_Department_Highest_Salary.sql
  - 196_Delete_Duplicate_Emails.sql
  - 197_Rising_Temperature.sql
  - 512_Game_Play_Analysis_II.sql
  - 569_Median_Employee_Salary.sql
  - 570_Managers_with_at_Least_5_Direct_Reports.sql
  - 571_Find_Median_Given_Frequency_of_Numbers.sql
  - 574_Winning_Candidate.sql
  - 579_Find_Cumulative_Salary_of_an_Employee.sql
  - 580_Count_Student_Number_in_Departments.sql
  - 602_Friend_Requests_II_Who_Has_the_Most_Friends.sql
  - 603_Consecutive_Available_Seats.sql
  - 607_Sales_Person.sql
  - 608_Tree_Node.sql
  - 613_Shortest_Distance_in_a_Line.sql
  - 614_Second_Degree_Follower.sql
  - 615_Average_Salary_Departments_VS_Company.sql
  - 618_Students_Report_By_Geography.sql
  - 626_Exchange_Seats.sql
- Subquery.md
Variable
Window-Function
Readme.md

613_Shortest_Distance_in_a_Line.sql

Create 613_Shortest_Distance_in_a_Line.sql

Mar 27, 2020

f95a215 · Mar 27, 2020