coding-ninjas-solutions

Description

The compiled solutions encompass all SQL questions, ranging from Hard to Ninjas (excluded Easy & Moderate ), on Code360 (prev: Coding Ninjas). These solutions were executed on the integrated PostgreSQL environment.

Solution Table

In the below tables, the columns indicate the following attributes related to the weekly challenge:

• ID : Identity column for individual challenge

• Challenge : Link to the SQL challenge hosted on Code360.

• Solution Script : Link to the solution SQL script hosted in this repository.

• Company : Name of the company where the questions were posed during the interview.

Table Of Contents

• Hard

• Ninjas

Difficulty : Hard 🔴 (29/29)

ID	Challenge	Solutions	Company
01	IMDB genre	Solution	Intuit
02	Rising Temperature	Solution	Amazon, Google
03	Consecutive Numbers	Solution	Flipkart
04	Winning Candidate	Solution	Meta
05	Count Student Number in Departments	Solution	Citibank
06	Exchange Seats	Solution	Morgan Stanley
07	Second Degree Follower	Solution	Groww
08	Biggest Window between Vists	Solution	Myntra, Goldman Sachs
09	CN Banned	Solution	Morgan Stanley
10	Maximum Transaction Each Day	Solution	Walmart
11	Department Top 3 Salaries	Solution	Microsoft
12	Immediate Food Delivery	Solution	MakeMyTrip
13	All Valid Triplets that can represent a Country	Solution	Thought Works, Microsoft, Siemens
14	Median Employee Salary	Solution	Goldman Sachs
15	Get the Second Most Activity	Solution	Amazon, Goldman Sachs
16	Find the Quiet Students in All Exams	Solution	Morgan Stanley, Walmart
17	Find Cumulative Salary of an Employee	Solution	Linkedin, Sprinklr
18	Find the Team Size	Solution	Meta, Siemens
19	Top Travellers	Solution	IBM, Amazon
20	New Users Daily Count	Solution	Goldman Sachs
21	Active Businesses	Solution	Samsung
22	Last Person to fit in the Bus	Solution	Flipkart
23	Capital Gain Loss	Solution	MakeMyTrip
24	Calculate Salaries	Solution	Atlassian, HSBC
25	Evaluate Bool Expressions	Solution	Atlassiain
26	Page Recommendations	Solution	Samsung
27	Trusted Contacts of User	Solution	Morgan Stanley, Goldman Sachs
28	Strong & Steady Friendship	Solution	Thought Works, Siemens
29	Percentage of Users attended a Contest	Solution	Thought Works

Difficulty : Ninjas 🟣 (16/16)

ID	Challenge	Solutions	Compaany
01	Department Highest Salary	Solution	Google, VMware Inc.
02	Managers with at least 5 direct Reports	Solution	Dunzo
03	Investments in 2016	Solution	Oracle
04	Tree Node	Solution	JP Morgan, Google
05	Shortest Distance in a Plane	Solution	Adobe
06	Find the Missing ID's	Solution	Amazon
07	Premier League Stats	Solution	Google, ZS Associates
08	Human Taffic Stadium	Solution	Deutsche Bank
09	Report Contiguous Dates	Solution	Google
10	Transactions per Vist	Solution	Microsoft, Morgan Stanley
11	Highest Grade for each Student	Solution	Microsoft
12	Product Price at a Given Date	Solution	Meta, HSBC
13	Rectangles Area	Solution	Morgan Stanley, JP Morgan
14	Bank Account Summary	Solution	Google, Microsoft, Amazon, VMware Inc.
15	Countries you can safely vist in	Solution	Groww, Microsoft, Meta, Google
16	Suspicious Bank Accounts	Solution	Intuit, Google

References

• Instant SQL Formatter

Contributing

Contributions are always welcome !!

If you would like to contribute to the project, please fork the repository and make a pull request.

Support

If you have any doubts, queries or, suggestions then, please connect with me on LinkedIn.

Do ⭐ the repository, if it inspired you, gave you ideas of your own or helped you in any way !!