Skip to content
/ Complex-SQL-Practice-for-Interview Public

I have tried to solve some complex SQL interview questions that had been asked in several company. Collected this question from Ankit Bansal. He made a organized playlist along with the solution. I have tried to figure out them first and then checked whether my query is correct or no. Thanks in advance.

97 stars 37 forks Branches Tags Activity
Star
Notifications You must be signed in to change notification settings

Ephemeral-Ahsan/Complex-SQL-Practice-for-Interview

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

26 Commits
3 or more consecutive empty seats
3 or more consecutive empty seats
 
 
Amazon music and upgraded to prime membership within the first 30 days of signing up
Amazon music and upgraded to prime membership within the first 30 days of signing up
 
 
An tricky SQL query to find period of date
An tricky SQL query to find period of date
 
 
Cities where COVID cases are increasing continuously
Cities where COVID cases are increasing continuously
 
 
Count no of first visited customer and repeated customer over order date
Count no of first visited customer and repeated customer over order date
 
 
Count no of total visit and most visited floor by person
Count no of total visit and most visited floor by person
 
 
Customer retention and churn analysis
Customer retention and churn analysis
 
 
Data Analyst Take Home Assignment by A Startup
Data Analyst Take Home Assignment by A Startup
 
 
Derive Point Table For ICC Tournamen
Derive Point Table For ICC Tournamen
 
 
Find the missing quarter
Find the missing quarter
 
 
Horizontal Sorting
Horizontal Sorting
 
 
Messages exchanged between two person
Messages exchanged between two person
 
 
Product pairs most commonly purchased together
Product pairs most commonly purchased together
 
 
README.md
README.md
 
 
Solving Tricky SQL Queries
Solving Tricky SQL Queries
 
 
Students with same mark in physics and Chemistry
Students with same mark in physics and Chemistry
 
 
User purchase platform
User purchase platform
 
 
cancellation rate of request with unbanned users by each date
cancellation rate of request with unbanned users by each date
 
 
count of company who have both two language users
count of company who have both two language users
 
 
find for each seller whether the brand of the second item (by date) whether they sold is their favorite brand
find for each seller whether the brand of the second item (by date) whether they sold is their favorite brand
 
 
find the winner in each group
find the winner in each group
 
 
second most recent activity
second most recent activity
 
 
total bill for employee based on billing period
total bill for employee based on billing period
 
 
trick to find the consecutive states start date to end date period
trick to find the consecutive states start date to end date period
 
 
write a query to find p_id,name,no of friends, sum of scores of person who have friends with total score greater than 100
write a query to find p_id,name,no of friends, sum of scores of person who have friends with total score greater than 100
 
 

Repository files navigation

Complex-SQL-Practice-for-Interview

I have tried to solve some complex SQL interview questions that had been asked in several company. Collected this question from Ankit Bansal. He made a organized playlist along with the solution. I have tried to figure out them first and then checked whether my query is correct or no. Thanks in advance.

About

I have tried to solve some complex SQL interview questions that had been asked in several company. Collected this question from Ankit Bansal. He made a organized playlist along with the solution. I have tried to figure out them first and then checked whether my query is correct or no. Thanks in advance.

Resources

Readme
Activity

Stars

97 stars

Watchers

2 watching

Forks

37 forks
Report repository

Releases

No releases published

Packages

No packages published