GitHub - shreyashji/SQL-Problem-Solving-learning: Adding SQL Concepts & problems which i solved day to day in this repo

Branches Tags

About

Adding SQL Concepts & problems which i solved day to day in this repo

leetcode leetcode-cpp leetcode-practice leetcode-sql mysql sql sql-server ssms

Activity

10 stars

2 watching

16 forks

Report repository

Navigation Menu

About

Releases

Packages

Contributors

Languages

Name		Name	Last commit message	Last commit date
Latest commit History 83 Commits
EM		EM
SQL interview some of the questions would be definitely from below list		SQL interview some of the questions would be definitely from below list
july2022 sql		july2022 sql
1.1 SQL_Interview_question_y.txt		1.1 SQL_Interview_question_y.txt
1.WindowingFunction-RANK,DENSE_RANK,ROW_NUMBER.sql		1.WindowingFunction-RANK,DENSE_RANK,ROW_NUMBER.sql
10.SQL Running Total Advance SQL Rolling N months SUM, AVG, MIN, MAX.sql		10.SQL Running Total Advance SQL Rolling N months SUM, AVG, MIN, MAX.sql
11.AK-Pareto Principle Implementation in SQL.sql		11.AK-Pareto Principle Implementation in SQL.sql
11.FIND 2ND HIGHEST SALARY.sql		11.FIND 2ND HIGHEST SALARY.sql
12.AK-Scenario based on join, group by and having clauses.sql		12.AK-Scenario based on join, group by and having clauses.sql
13.CTE(Common Table Expression) example.sql		13.CTE(Common Table Expression) example.sql
14.SOLVE_15_SQL_QUERRIES.sql		14.SOLVE_15_SQL_QUERRIES.sql
15.Lead&Lag Window Analytical functions in SQL.sql		15.Lead&Lag Window Analytical functions in SQL.sql
16.SQL_INTERVIEW.sql		16.SQL_INTERVIEW.sql
17.Difference between Where and Having Clause in SQL.sql		17.Difference between Where and Having Clause in SQL.sql
18.lead lag window function.sql		18.lead lag window function.sql
19.Charnindex & SplitString function in sql.sql		19.Charnindex & SplitString function in sql.sql
2.AK-matches_won_loss_of_match.sql		2.AK-matches_won_loss_of_match.sql
20.Calculate number of weekdays between two dates Exclude Weekends,DateDiff DateName.sql		20.Calculate number of weekdays between two dates Exclude Weekends,DateDiff DateName.sql
21.Case When Statement in SQL.sql		21.Case When Statement in SQL.sql
22.AK-Leetcode Hard Problem Complex SQL 7 Trips and Users.sql		22.AK-Leetcode Hard Problem Complex SQL 7 Trips and Users.sql
23.Replace, Stuff, Substring and Translate SQL String Functions.sql		23.Replace, Stuff, Substring and Translate SQL String Functions.sql
24.SQL JOINS Tutorial Using a Case Study.sql		24.SQL JOINS Tutorial Using a Case Study.sql
25.Methods To Calculate Median With SQL.sql		25.Methods To Calculate Median With SQL.sql
26.AK-Tournament Winners problem.sql		26.AK-Tournament Winners problem.sql
27.AK-Leetcode Hard Problem 3 Market Analysis 2.sql		27.AK-Leetcode Hard Problem 3 Market Analysis 2.sql
28.AK-tricky sql question.sql		28.AK-tricky sql question.sql
29.leetcode 5 question.sql		29.leetcode 5 question.sql
3.Self_Join_Concept_Employee_Salary_More_than_Manager's_Salary.sql		3.Self_Join_Concept_Employee_Salary_More_than_Manager's_Salary.sql
30.Working with SQL NULL values Null Handling Functions.sql		30.Working with SQL NULL values Null Handling Functions.sql
31.AK-lettcode problem.sql		31.AK-lettcode problem.sql
32.How to Write SQL with CTE_SQL With Clause_Common Table Expression.sql		32.How to Write SQL with CTE_SQL With Clause_Common Table Expression.sql
33.Recursive CTE.sql		33.Recursive CTE.sql
34.Practice SQLs Without Creating Tables In Your Database.sql		34.Practice SQLs Without Creating Tables In Your Database.sql
35.Data Science SQL Interview Question Recommendation System.sql		35.Data Science SQL Interview Question Recommendation System.sql
36.1 Remove leading and trailing zeroes from a decimal.sql		36.1 Remove leading and trailing zeroes from a decimal.sql
36.10 How to increment salaries of employees who have 2 years with the organization Datediff.sql		36.10 How to increment salaries of employees who have 2 years with the organization Datediff.sql
36.11 Unpivot Convert data from columns into Rows.sql		36.11 Unpivot Convert data from columns into Rows.sql
36.12 Pivot Convert data from Rows to Columns.sql		36.12 Pivot Convert data from Rows to Columns.sql
36.13 Dynamic Pivot How to dynamically convert rows into columns.sql		36.13 Dynamic Pivot How to dynamically convert rows into columns.sql
36.14 How to find employees hired in last n months Datediff.sql		36.14 How to find employees hired in last n months Datediff.sql
36.15 How to capitalize first letter of a string.sql		36.15 How to capitalize first letter of a string.sql
36.16 How to find employees retiring at the end of the month DATEADD EOMONTH.sql		36.16 How to find employees retiring at the end of the month DATEADD EOMONTH.sql
36.17 How to identify Overlapping Date Ranges.sql		36.17 How to identify Overlapping Date Ranges.sql
36.18 Count the occurrence of a character in a string.sql		36.18 Count the occurrence of a character in a string.sql
36.19 Find names that startend with More examples Like Pattern Matching.sql		36.19 Find names that startend with More examples Like Pattern Matching.sql
36.2 How to Extract Numbers and Alphabets from an alphanumeric string Translate function.sql		36.2 How to Extract Numbers and Alphabets from an alphanumeric string Translate function.sql
36.20 How to find strings with lower case characters Case Insensitive Collate.sql		36.20 How to find strings with lower case characters Case Insensitive Collate.sql
36.21 Difference between Countstar Count1 Countcolname.sql		36.21 Difference between Countstar Count1 Countcolname.sql
36.22 How to find Maximum of multiple columns.sql		36.22 How to find Maximum of multiple columns.sql
36.23 How to find n consecutive date records Sales for at least n consecutive days.sql		36.23 How to find n consecutive date records Sales for at least n consecutive days.sql
36.24 No sales for n consecutive days Identify date gaps.sql		36.24 No sales for n consecutive days Identify date gaps.sql
36.25 How to find First and Last day of week.sql		36.25 How to find First and Last day of week.sql
36.26 How to find top n salaries in a department and sum the remaining as 'Others'.sql		36.26 How to find top n salaries in a department and sum the remaining as 'Others'.sql
36.27 Compare monthly sales with previous month, same month previous year, first month of year.sql		36.27 Compare monthly sales with previous month, same month previous year, first month of year.sql
36.28 How to find number of emails from the same domain.sql		36.28 How to find number of emails from the same domain.sql
36.29 How to find all levels of Employee Manager Hierarchy Recursion.sql		36.29 How to find all levels of Employee Manager Hierarchy Recursion.sql
36.3 How to calculate Running Totals and Cumulative Sum.sql		36.3 How to calculate Running Totals and Cumulative Sum.sql
36.30 SQL Query to find a leap year 2 methods.sql		36.30 SQL Query to find a leap year 2 methods.sql
36.31 How to generate date records for a Calendar table.sql		36.31 How to generate date records for a Calendar table.sql
36.32 What is the difference between Translate and Replace.sql		36.32 What is the difference between Translate and Replace.sql
36.4 How to calculate YTD and MTD totals Window Functions.sql		36.4 How to calculate YTD and MTD totals Window Functions.sql
36.5 How to calculate the First and Last Order FIRST_VALUE LAST_VALUE Window Functions.sql		36.5 How to calculate the First and Last Order FIRST_VALUE LAST_VALUE Window Functions.sql
36.6 Find employees with salary less than Dept average but more than average of any other Dept ANY.sql		36.6 Find employees with salary less than Dept average but more than average of any other Dept ANY.sql
36.7 How to find employees with highest salary in a department.sql		36.7 How to find employees with highest salary in a department.sql
36.8 Find employees with salary greater than department average and less than company average.sql		36.8 Find employees with salary greater than department average and less than company average.sql
36.9 How to find employees with salary greater than their managers salary.sql		36.9 How to find employees with salary greater than their managers salary.sql
36.Check For Alphanumeric values.sql		36.Check For Alphanumeric values.sql
37. AK-How to Delete Duplicates in Production Environment.sql		37. AK-How to Delete Duplicates in Production Environment.sql
38. Amazon Prime Subscription Rate SQL Logic.sql		38. Amazon Prime Subscription Rate SQL Logic.sql
39.1 Yelp Top Cool Votes problem.sql		39.1 Yelp Top Cool Votes problem.sql
39.Amazon problem Highest Cost Orders.sql		39.Amazon problem Highest Cost Orders.sql
4.AK-find new and repeat customers.sql		4.AK-find new and repeat customers.sql
40.AK-SQL Cross Join Use Cases Master Data Performance Data.sql		40.AK-SQL Cross Join Use Cases Master Data Performance Data.sql
41.cs-Highest Energy Consumption.sql		41.cs-Highest Energy Consumption.sql
42. AK -Most Asked SQL JOIN based Interview Question no. of Records after 4 types of JOINs.sql		42. AK -Most Asked SQL JOIN based Interview Question no. of Records after 4 types of JOINs.sql
43. AK- all joins most asked question.sql		43. AK- all joins most asked question.sql
44. AK- all joins with diff values.sql		44. AK- all joins with diff values.sql
45. AK- ALL JOINS with nulls.sql		45. AK- ALL JOINS with nulls.sql
46.AK-Customer Retention and Churn Analysis PART-1 SQL Interview Question Product Based Companies.sql		46.AK-Customer Retention and Churn Analysis PART-1 SQL Interview Question Product Based Companies.sql
47. AK-How to Calculate Mode in SQL How to Find Most Frequent Value in a Column.sql		47. AK-How to Calculate Mode in SQL How to Find Most Frequent Value in a Column.sql
48. AK-Second Most Recent Activity SQL.sql		48. AK-Second Most Recent Activity SQL.sql
49. AK-find the change in employee status.sql		49. AK-find the change in employee status.sql
5.AK-Scenario based Interviews Question for Product companies.sql		5.AK-Scenario based Interviews Question for Product companies.sql
50. AK-Scenario Based SQL Question Solving Using SCD Type 2 Concept.sql		50. AK-Scenario Based SQL Question Solving Using SCD Type 2 Concept.sql
51. AK-A Simple and Tricky SQL Question Rank Only Duplicates.sql		51. AK-A Simple and Tricky SQL Question Rank Only Duplicates.sql
52.AK- Data Analyst Take Home Assignment by A Startup Spotify Case Study.sql		52.AK- Data Analyst Take Home Assignment by A Startup Spotify Case Study.sql
53. AK- Advance SQL Queries Consecutive Empty Seats.sql		53. AK- Advance SQL Queries Consecutive Empty Seats.sql
56. Difference between Row Number, Rank and Dense Rank Tie-breaking scenario.sql		56. Difference between Row Number, Rank and Dense Rank Tie-breaking scenario.sql
57.How to generate match schedule for list of countries Match one row with all other rows.sql		57.How to generate match schedule for list of countries Match one row with all other rows.sql
58. AK-finding missing quater.sql		58. AK-finding missing quater.sql
58.Replace multiple commas with a single comma.sql		58.Replace multiple commas with a single comma.sql
59. AK-find students with same marks in physics & chemistry Deadly Combination of Group By and Having Clause in SQL.sql		59. AK-find students with same marks in physics & chemistry Deadly Combination of Group By and Having Clause in SQL.sql
59.Sort by one country always at top and others in ascending order Custom sorting.sql		59.Sort by one country always at top and others in ascending order Custom sorting.sql
6.Top_10_SQL_interview_Questions_and Answers_Frequently_asked_SQL_interview_questions.sql		6.Top_10_SQL_interview_Questions_and Answers_Frequently_asked_SQL_interview_questions.sql
60. SQL Queries for experienced.sql		60. SQL Queries for experienced.sql
61. User has to display all these fields along with maximum TranAmt for each CustID and ratio of TranAmt and maximum TranAmt for each transaction..sql		61. User has to display all these fields along with maximum TranAmt for each CustID and ratio of TranAmt and maximum TranAmt for each transaction..sql
62.1 Amazon Complex SQL Interview Questions Group BY JOINS OR MULTIPLE QUERIES.sql		62.1 Amazon Complex SQL Interview Questions Group BY JOINS OR MULTIPLE QUERIES.sql
63. AK - find cities where covid cases increasing continuously.sql		63. AK - find cities where covid cases increasing continuously.sql
64.AK- Google SQL Interview Question for Data Analyst Position.sql		64.AK- Google SQL Interview Question for Data Analyst Position.sql
65-AK Sorting Happiness Index Data with India on Top.sql		65-AK Sorting Happiness Index Data with India on Top.sql

Folders and files

Latest commit

History

About

Topics

Stars

Watchers

Forks

Releases

Packages

Contributors

Languages