SQL-Practice

Here i have uploaded the question and solution of the top 100 question by coding ninjas https://www.codingninjas.com/codestudio/problem-lists/top-100-sql-problems

Name		Name	Last commit message	Last commit date
Activity Participants 15-10-22		Activity Participants 15-10-22
Ad-Free Sessions 6-10-22		Ad-Free Sessions 6-10-22
All Valid Triplets That Can Represent a Country 29-10-22		All Valid Triplets That Can Represent a Country 29-10-22
All the Pairs With the Maximum Number of Common Followers 25-10-22		All the Pairs With the Maximum Number of Common Followers 25-10-22
Apples & Oranges 13-10-22		Apples & Oranges 13-10-22
Article 11-10-22		Article 11-10-22
Bank Account Summary 22-11-22		Bank Account Summary 22-11-22
Big Countries 30 -9-22		Big Countries 30 -9-22
Biggest Single Number 9-10-22		Biggest Single Number 9-10-22
Biggest Window Between Visits 26-10-22		Biggest Window Between Visits 26-10-22
CN Banned 8-10-22		CN Banned 8-10-22
Calculate Salaries 17-10-2022		Calculate Salaries 17-10-2022
Capital Gain Loss 5-07-22		Capital Gain Loss 5-07-22
Classes with more than 5 students 3-10-22		Classes with more than 5 students 3-10-22
Confirmation of Signups 20-10-22		Confirmation of Signups 20-10-22
Consecutive Available Seats 11-10-22		Consecutive Available Seats 11-10-22
Consecutive Numbers 3-10-22		Consecutive Numbers 3-10-22
Count Student Number in Department 25-9-2022		Count Student Number in Department 25-9-2022
Create a Session Bar Chart 25-10-22		Create a Session Bar Chart 25-10-22
Customer Placing the Largest Number Orders 8-10-22		Customer Placing the Largest Number Orders 8-10-22
Customers Who Bought All Products 18-10-22		Customers Who Bought All Products 18-10-22
Customers Who Never Order 30-9-22		Customers Who Never Order 30-9-22
Delete Duplicate emails 5-10-22		Delete Duplicate emails 5-10-22
Department Highest sallery 27-9-22		Department Highest sallery 27-9-22
Duplicate Emails 7-10-22		Duplicate Emails 7-10-22
Employee bonus 29-9-22		Employee bonus 29-9-22
Employees Earning More Than Their Manager 4-10-22		Employees Earning More Than Their Manager 4-10-22
Exchange Seats 27-10-22		Exchange Seats 27-10-22
Find the Team Size 17-10-22		Find the Team Size 17-10-22
Fix Names in a Table 13-10-22		Fix Names in a Table 13-10-22
Fix the Issue 6-10-22		Fix the Issue 6-10-22
Friend Request 25-10-22		Friend Request 25-10-22
Get the Second Most Recent Activity - 27-9-22		Get the Second Most Recent Activity - 27-9-22
Group Employees of the Same Salary 23-10-22		Group Employees of the Same Salary 23-10-22
IMDB rating 29-4-22		IMDB rating 29-4-22
IMDb Genre 29-9-22		IMDb Genre 29-9-22
IMDb Metacritic Rating 29-9-22		IMDb Metacritic Rating 29-9-22
Immediate Food Delivery 18-10-22		Immediate Food Delivery 18-10-22
Investments in 2016 22-11-22		Investments in 2016 22-11-22
Last Person to Fit in the Bus 30-11-22		Last Person to Fit in the Bus 30-11-22
Managers with at Least 5 Direct Reports 6-10-22		Managers with at Least 5 Direct Reports 6-10-22
Marvel Cities 7-10-22		Marvel Cities 7-10-22
Maximum Transaction Each Day 3-10-22		Maximum Transaction Each Day 3-10-22
NPV Queries 8-10-22		NPV Queries 8-10-22
New Users Daily Count 30-11-22		New Users Daily Count 30-11-22
Number of Calls Between Two Persons 7-10-22		Number of Calls Between Two Persons 7-10-22
Number of Comments per Post 13-10-22		Number of Comments per Post 13-10-22
Orders With Maximum Quantity Above Average 10-10-22		Orders With Maximum Quantity Above Average 10-10-22
Page Recommendations 26-10-22		Page Recommendations 26-10-22
Product Price at a Given Date 11-11-22		Product Price at a Given Date 11-11-22
Product's Worth Over Invoices 10-10-22		Product's Worth Over Invoices 10-10-22
Queries Quality and Percentage 12-10-22		Queries Quality and Percentage 12-10-22
README.md		README.md
Rank Scores 5-10-22		Rank Scores 5-10-22
Recyclable and Low Fat Products 3-10-22		Recyclable and Low Fat Products 3-10-22
Reformat Department Table 10-10-22		Reformat Department Table 10-10-22
Rising Teperature 26-9-22		Rising Teperature 26-9-22
Running Total for Different Genders 19-10-22		Running Total for Different Genders 19-10-22
Second Degree Follower 5-10-22		Second Degree Follower 5-10-22
Second Highest Sallery 24 - 9 -22		Second Highest Sallery 24 - 9 -22
Sellers With No Sales 10-10-22		Sellers With No Sales 10-10-22
Shortest Distance 10-10-22		Shortest Distance 10-10-22
Sptify Session 24-9-22		Sptify Session 24-9-22
Students DB 30-9-22		Students DB 30-9-22
The Latest Login in 2020 12-10-22		The Latest Login in 2020 12-10-22
Top Travellers 17-10-22		Top Travellers 17-10-22
Tree Node 14-11-2022		Tree Node 14-11-2022
Triangle Judgement 8-10-22		Triangle Judgement 8-10-22
Warehouse Manager 6-10-22		Warehouse Manager 6-10-22
Winning Candidate 24-9-22		Winning Candidate 24-9-22
directors actor 28-9-22		directors actor 28-9-22
students DB 26-9-22		students DB 26-9-22
swap salary 28-9-22		swap salary 28-9-22

Navigation Menu

Repository files navigation

SQL-Practice

About

Releases

Packages

Contributors

Latest commit

History

Folders and files

Repository files navigation

SQL-Practice

About

Topics

Resources

Stars

Watchers

Forks

Releases

Packages

Contributors