Skip to content

SimonFans/SQL

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

118 Commits
SQL_Functions
SQL_Functions
 
 
Convoy_lane.sql
Convoy_lane.sql
 
 
HBO_Count_Time_Duration.sql
HBO_Count_Time_Duration.sql
 
 
L 196 Delete Duplicated Emails.sql
L 196 Delete Duplicated Emails.sql
 
 
L 197 Rising Temperature.md
L 197 Rising Temperature.md
 
 
L 262 Trips and Users.md
L 262 Trips and Users.md
 
 
L 569 Median Employee Salary.md
L 569 Median Employee Salary.md
 
 
L 570 Managers with at least 5 Direct Reports.md
L 570 Managers with at least 5 Direct Reports.md
 
 
L 571 Find Median Given Frequency of Numbers.md
L 571 Find Median Given Frequency of Numbers.md
 
 
L 574 Winning Candidate.md
L 574 Winning Candidate.md
 
 
L 577 Employee Bonus.md
L 577 Employee Bonus.md
 
 
L 578 Get Highest Answer Rate.sql
L 578 Get Highest Answer Rate.sql
 
 
L 596 Classes More Than 5 Students.md
L 596 Classes More Than 5 Students.md
 
 
L 601 Human Traffic of Stadium.sql
L 601 Human Traffic of Stadium.sql
 
 
L 620 Not Boring Movies.md
L 620 Not Boring Movies.md
 
 
L 626 Exchange Seats.md
L 626 Exchange Seats.md
 
 
L 627 Swap Salary.md
L 627 Swap Salary.md
 
 
L1083_Sales_Analysis.sql
L1083_Sales_Analysis.sql
 
 
L1107_New Users Daily Count.sql
L1107_New Users Daily Count.sql
 
 
L1164_Product Price at a Given Date.sql
L1164_Product Price at a Given Date.sql
 
 
L1179_ Reformat Department Table.sql
L1179_ Reformat Department Table.sql
 
 
L1204_Last Person to Fit in the Elevator.sql
L1204_Last Person to Fit in the Elevator.sql
 
 
L1212_Team_Scores_in_Football_Tournament.sql
L1212_Team_Scores_in_Football_Tournament.sql
 
 
L1264_Page Recommendations.sql
L1264_Page Recommendations.sql
 
 
L1321_Restaurant Growth.sql
L1321_Restaurant Growth.sql
 
 
L175 Combine Two Tables.md
L175 Combine Two Tables.md
 
 
L176 Second Highest Salary.md
L176 Second Highest Salary.md
 
 
L178 Rank Scores.sql
L178 Rank Scores.sql
 
 
L180 Consecutive Numbers.md
L180 Consecutive Numbers.md
 
 
L181 Emplyee Earning More Than Their Manager.md
L181 Emplyee Earning More Than Their Manager.md
 
 
L182 Duplicate Emails.md
L182 Duplicate Emails.md
 
 
L183 Customers Who Never Order.md
L183 Customers Who Never Order.md
 
 
L184 Department Highest Salary.md
L184 Department Highest Salary.md
 
 
L185 Department Top Three Salaries.sql
L185 Department Top Three Salaries.sql
 
 
L534_Game_Play_Analysis III.sql
L534_Game_Play_Analysis III.sql
 
 
L550_Game Play Analysis IV.sql
L550_Game Play Analysis IV.sql
 
 
L579_Find Cumulative Salary of an Employee.sql
L579_Find Cumulative Salary of an Employee.sql
 
 
L580_Count Student Number in Departments.sql
L580_Count Student Number in Departments.sql
 
 
L584_Find_Customer_Referee.sql
L584_Find_Customer_Referee.sql
 
 
L585_Investments in 2016.sql
L585_Investments in 2016.sql
 
 
L597_Friend Requests I: Overall Acceptance Rate.sql
L597_Friend Requests I: Overall Acceptance Rate.sql
 
 
L602_Friend Requests II: Who Has the Most FriendsII.py
L602_Friend Requests II: Who Has the Most FriendsII.py
 
 
L603_Consecutive_Available_Seats.sql
L603_Consecutive_Available_Seats.sql
 
 
L607_Sales_Person.sql
L607_Sales_Person.sql
 
 
L608_Tree_Node.sql
L608_Tree_Node.sql
 
 
L610_Triangle_Judgement.sql
L610_Triangle_Judgement.sql
 
 
L612_Shortest Distance in a Plane.sql
L612_Shortest Distance in a Plane.sql
 
 
L613_Shortest Distance in a Line .sql
L613_Shortest Distance in a Line .sql
 
 
L614_Second_Degree_Follower.sql
L614_Second_Degree_Follower.sql
 
 
L615_Average Salary: Departments VS Company.sql
L615_Average Salary: Departments VS Company.sql
 
 
L618_Students Report By Geography.sql
L618_Students Report By Geography.sql
 
 
L619_Biggest_Single_Number.sql
L619_Biggest_Single_Number.sql
 
 
README.md
README.md
 
 
Second_High_Salary_In_Each_Dept.sql
Second_High_Salary_In_Each_Dept.sql
 
 
Wayfair_Company_Export_Import.sql
Wayfair_Company_Export_Import.sql
 
 
replace_null_value_with_value_previous_value.sql
replace_null_value_with_value_previous_value.sql
 
 

Repository files navigation

About

List all SQL interview questions

Resources

Readme
Activity

Stars

19 stars

Watchers

0 watching

Forks

5 forks
Report repository

Releases

No releases published

Packages

No packages published

Contributors 2

  •  
  •  

Languages