Hello Programmers/Coders, Today we are going to share solutions of Programming problems of HackerRank of Programming Language SQL. At Each Problem with Successful submission with all Test Cases Passed, you will get an score or marks. And after solving maximum problems, you will be getting stars. This will highlight your profile to the recruiters.
In this post, you will find the solution for New Companies in SQL-HackerRank Problem. We are providing the correct and tested solutions of coding problems present on HackerRank. If you are not able to solve any problem, then you can take help from our Blog/website.
Use “Ctrl+F” To Find Any Questions Answer. & For Mobile User, You Just Need To Click On Three dots In Your Browser & You Will Get A “Find” Option There. Use These Option to Get Any Random Questions Answer.
Introduction To SQL
SQL stands for Structured Query Language. SQL is used to create, remove, alter the database and database objects in a database management system and to store, retrieve, update the data in a database. SQL is a standard language for creating, accessing, manipulating database management system. SQL works for all modern relational database management systems, like SQL Server, Oracle, MySQL, etc.
- It is a standard language for Relational Database System. It enables a user to create, read, update and delete relational databases and tables.
- All the RDBMS like MySQL, Informix, Oracle, MS Access and SQL Server use SQL as their standard database language.
- SQL allows users to query the database in a number of ways, using English-like statements.
Link for the Problem – New Companies SQL – Hacker Rank Solution
New Companies SQL – Hacker Rank Solution
Problem:
Amber’s conglomerate corporation just acquired some new companies. Each of the companies follows this hierarchy:
Given the table schemas below, write a query to print the company_code, founder name, total number of lead managers, total number of senior managers, total number of managers, and total number of employees. Order your output by ascending company_code.
Note:
- The tables may contain duplicate records.
- The company_code is string, so the sorting should not be numeric. For example, if the company_codes are C_1, C_2, and C_10, then the ascending company_codes will be C_1, C_10, and C_2.
Input Format
The following tables contain company data:
- Company: The company_code is the code of the company and founder is the founder of the company.
- Lead_Manager: The lead_manager_code is the code of the lead manager, and the company_code is the code of the working company.
- Senior_Manager: The senior_manager_code is the code of the senior manager, the lead_manager_code is the code of its lead manager, and the company_code is the code of the working company.
- Manager: The manager_code is the code of the manager, the senior_manager_code is the code of its senior manager, the lead_manager_code is the code of its lead manager, and the company_code is the code of the working company.
-
- Employee: The employee_code is the code of the employee, the manager_code is the code of its manager, the senior_manager_code is the code of its senior manager, the lead_manager_code is the code of its lead manager, and the company_code is the code of the working company.
-
Sample Input
Company Table: 
Lead_Manager Table: 
Senior_Manager Table: 
Manager Table: 
Employee Table: 
Sample Output
C1 Monika 1 2 1 2 C2 Samantha 1 1 2 2
Explanation
In company C1, the only lead manager is LM1. There are two senior managers, SM1 and SM2, under LM1. There is one manager, M1, under senior manager SM1. There are two employees, E1 and E2, under manager M1.
In company C2, the only lead manager is LM2. There is one senior manager, SM3, under LM2. There are two managers, M2 and M3, under senior manager SM3. There is one employee, E3, under manager M2, and another employee, E4, under manager, M3.
New Companies SQL – Hacker Rank Solution
SELECT C.COMPANY_CODE,
C.FOUNDER,
(SELECT COUNT(DISTINCT LEAD_MANAGER_CODE)
FROM LEAD_MANAGER L
WHERE L.COMPANY_CODE = C.COMPANY_CODE),
(SELECT COUNT(DISTINCT SENIOR_MANAGER_CODE)
FROM SENIOR_MANAGER S
WHERE S.COMPANY_CODE = C.COMPANY_CODE),
(SELECT COUNT(DISTINCT MANAGER_CODE)
FROM MANAGER M
WHERE M.COMPANY_CODE = C.COMPANY_CODE),
(SELECT COUNT(DISTINCT EMPLOYEE_CODE)
FROM EMPLOYEE E
WHERE E.COMPANY_CODE = C.COMPANY_CODE)
FROM COMPANY C
ORDER BY C.COMPANY_CODE ASC;
The core of your writing whilst sounding reasonable in the beginning, did not sit perfectly with me personally after some time. Somewhere throughout the paragraphs you actually were able to make me a believer but only for a while. I however have a problem with your jumps in assumptions and you might do well to fill in those breaks. If you actually can accomplish that, I could undoubtedly be impressed.
Hello my friend! I want to say that this post is amazing, nice written and come with almost all significant infos. I?¦d like to peer extra posts like this .
Undeniably imagine that which you stated. Your favorite justification seemed to be on the net the simplest factor to understand of. I say to you, I definitely get irked while other people think about concerns that they plainly don’t recognise about. You controlled to hit the nail upon the highest and outlined out the entire thing without having side effect , people could take a signal. Will probably be back to get more. Thanks
Lovely just what I was looking for.Thanks to the author for taking his clock time on this one.
Can I simply say what a aid to seek out someone who truly is aware of what theyre talking about on the internet. You positively know easy methods to bring a problem to gentle and make it important. More individuals need to read this and perceive this aspect of the story. I cant consider youre no more fashionable because you definitely have the gift.
It’s the best time to make a few plans for the longer term and it is time to be happy. I have learn this submit and if I may just I want to suggest you few interesting issues or suggestions. Maybe you could write subsequent articles regarding this article. I desire to read more things approximately it!
You are a very clever person!
Hello just wanted to give you a quick heads up. The text in your content seem to be running off the screen in Firefox. I’m not sure if this is a format issue or something to do with internet browser compatibility but I figured I’d post to let you know. The layout look great though! Hope you get the problem solved soon. Kudos
I will right away snatch your rss as I can not in finding your e-mail subscription hyperlink or newsletter service. Do you have any? Please permit me recognize in order that I could subscribe. Thanks.
I got what you intend, appreciate it for putting up.Woh I am glad to find this website through google. “Do not be too timid and squeamish about your actions. All life is an experiment.” by Ralph Waldo Emerson.
As I website owner I conceive the subject matter here is really superb, thankyou for your efforts.
Utterly composed subject material, regards for entropy. “The bravest thing you can do when you are not brave is to profess courage and act accordingly.” by Corra Harris.
so much fantastic information on here, : D.
Howdy! I know this is kinda off topic but I’d figured I’d ask. Would you be interested in exchanging links or maybe guest authoring a blog article or vice-versa? My site discusses a lot of the same subjects as yours and I believe we could greatly benefit from each other. If you’re interested feel free to send me an e-mail. I look forward to hearing from you! Superb blog by the way!
I got what you mean , thankyou for posting.Woh I am delighted to find this website through google.
I wanted to draft you the bit of remark to finally thank you very much once again relating to the lovely suggestions you’ve contributed on this site. It has been certainly shockingly generous with people like you to grant openly what most of us would have made available as an e book to help make some profit for their own end, mostly since you might well have done it in the event you considered necessary. Those thoughts in addition worked to be the easy way to be sure that other people online have similar passion really like my own to know the truth a lot more with regard to this matter. I’m certain there are a lot more enjoyable times up front for those who start reading your website.
I?¦m not positive where you are getting your information, however great topic. I must spend a while studying much more or working out more. Thank you for fantastic information I used to be on the lookout for this information for my mission.
Pretty! This was a really wonderful post. Thank you for your provided information.
order cialis 40mg tadalafil tablet top erection pills
order estrace 2mg without prescription prazosin 2mg over the counter order minipress 1mg online
vermox pill order vermox for sale tadalafil 10mg tablet
buy cleocin cheap buy erythromycin 500mg generic order sildenafil 100mg pills
where to buy avanafil without a prescription tadalafil for sale online diclofenac pills
nolvadex 10mg without prescription order tamoxifen 10mg sale ceftin 500mg pills
indomethacin 50mg us indocin price brand cefixime 100mg
trimox 250mg pills buy amoxicillin 250mg generic clarithromycin cost
order bimatoprost pill trazodone sale buy trazodone sale
buy clonidine without prescription buy generic catapres brand tiotropium bromide 9 mcg
buy minocin no prescription cheap hytrin how to buy actos
order leflunomide 20mg without prescription buy sildenafil 100mg pill order azulfidine 500mg without prescription
isotretinoin 40mg ca order azithromycin 250mg online azithromycin where to buy
cheap tadalafil 40mg buy viagra without prescription order tadalafil 20mg generic
order azipro 250mg pills omnacortil uk neurontin order
ivermectin 12 mg without a doctor prescription buy generic stromectol order deltasone 20mg for sale
buy lasix 100mg online cheap order doxycycline sale how to buy albuterol
As a Newbie, I am continuously searching online for articles that can help me. Thank you
generic levitra 10mg levitra 10mg pill buy generic plaquenil online
altace us buy amaryl online etoricoxib 120mg sale
vardenafil 20mg without prescription order hydroxychloroquine 400mg sale buy hydroxychloroquine 400mg pill
Hi, Neat post. There is a problem with your web site in internet explorer, would test this… IE still is the market leader and a big portion of people will miss your fantastic writing due to this problem.