Hackerrank SQL Solutions | SQL Project Planning Hackerrank Medium Problem
ฝัง
- เผยแพร่เมื่อ 12 ก.พ. 2021
- Find the code to this problem: github.com/MarkusFriemann/Hac...
You find this problem at:
www.hackerrank.com/challenges...
____________________________________________
SUBSCRIBE!
Do you want to understand how to solve SQL Problems in every detail? That's what my channel is about. When I was younger I thought I could never program because it looked way too difficult. The truth is that it takes time but with some patience anybody can do it! Follow me along and get better!
____________________________________________
SUPPORT MY CHANNEL
🙌The best way to support my channel right now is to give me a Super Thanks. You can do that by clicking thanks next to the title of the video. It is much appreciated!
____________________________________________
💾GitHub: github.com/CuriosityLeonardo?...
✋Add me on LinkedIn to get in contact: / markus-friemann-221b3814b
The whole series of SQL Hackerrank is so helpful. Very systematic, step-by-step outputs and explanation. Just amazing! Thank you Markus.
very unique way of teaching. You started from the scratch, divided the problem into bits and the solved it bits by bits. exactly how a students wants it. VERY HELPFUL, THANK YOU.
I think you should make more tutorial videos on SQL and other topics because your way of explaining is very clear and easily understandable. Thank you
Superb way of explaining .... Much appreciated!
Thank you so much for the wonderful explanation.
Markus, we need more such videos from you. Can you please make these for all other medium level hacker rank questions? Would be so so helpful !!
Just for you Faisal, I did a new video with ALL other medium problems and ALL hard and easy SQL Problems: th-cam.com/video/vpzO8QTrgbc/w-d-xo.html Enjoy!
Thank you for the video !
Great Explanation: MySQL answer is : WITH Project_Start_Date AS (
SELECT Start_Date, RANK() OVER (ORDER BY Start_Date) AS Rank_Start
FROM Projects
WHERE Start_Date NOT IN (SELECT End_Date FROM Projects)
),
Project_End_Date AS (
SELECT End_Date, RANK() OVER (ORDER BY End_Date) AS Rank_End
FROM Projects
WHERE End_Date NOT IN (SELECT Start_Date FROM Projects)
)
SELECT Start_Date, End_Date
FROM Project_Start_Date, Project_End_Date
where Rank_Start = Rank_End
ORDER BY DATEDIFF(End_Date, Start_Date), Start_Date
thank you for the great explanation, I learnt a lot!
That's awesome! Im glad you could take something away from it. Keep learning!
very well explained
great explaination
thank you for this!
You are welcome! Please Like and Subscribe for more SQL Videos :)
Absolutely amazing way of explaining the question and finding logic. Thanks, Markus
would it be possible for you to make some solution videos in MySQL also? It will be very helpful :)
Great Idea thanks! I will definitely consider it for future videos :)
Amazing Question and more amazing solution explanation : )
Thanks! ❤️
You Deserve A Sub bro ❤
Thanks Jaydip! ♥️
great explanation sir, but dont u think even dense_rank would work or also row_number??
Hi TJ! Yes, indeed dense_rank and row_number also work in this Problem, nice add!
I don't understand how this logic worked, because for task IDs 10, 15, and 11, the start dates are in the list of end date column.
waow great explaination sir
Thanks Anirudh!
Sound issue sir. But overall explanation is awesome 🙂.
Thanks Binod. Newer videos are with an external microphone and better sound quality. Check for example this Video about the "Challenges" Problem on Hackerrank: th-cam.com/video/00yN5ERtxbI/w-d-xo.html
nailed it..
Thanks Vikas!
thank you sir
Most welcome
super awesome
Thanks!
HI
What are the cities that are represented by either customers or employees more than two times?
Result set:
CITY TIMES
... ....
.. ...
.. ...
I need this types of solution
where can i find which videos helfull for me ..
CAn you help me
Hi Cavid
Maybe something like:
Select
City,
Count(City) as Times
From table
Group By City
Can you post your tables and columns?
Audio quality is not as per the video !! please make sure your audio is clearly audible!
And great effort but sir !❤️
Thanks for the Feedback Manoj. Audio Quality will get much better in Future videos!
Unable to understand your voice due to echo sound
Hi Varun, sorry for that, that was before I got a microphone. Try out this video with ALL Hackerrank solutions, most of them with good sound quality: th-cam.com/video/vpzO8QTrgbc/w-d-xo.html&ab_channel=TheCodingMentor 🤗
very poor sound quality. Explanation was good
Thanks for your Feedback. Glad you like the explanation :) Sound quality improves with newer videos!
Sounds echo in your voice..its irritating
Hi Varun, sorry for that, that was before I got a microphone. Try out this video with ALL Hackerrank solutions, most of them with good sound quality: th-cam.com/video/vpzO8QTrgbc/w-d-xo.html&ab_channel=TheCodingMentor
@@thecodingmentor7701 ya I watch your most of video..all are good having very nicely explained.. Thankyou