SQL BASIC Certification Skills Test on Hackerrank Detailed SOLUTION!

In this video I am solving the BASIC Certification on Hackerrank. Watch also my other videos on Hackerrank SQL Certifications.
____________________________________________
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
____________________________________________

[@derekchen2897]

Hi, your video is very helpful, could you do SQL (Advanced) Skills Certification Test?

[@thecodingmentor7701]

Hi Derek, great idea! Im quite busy at the moment but I hope I will have soon a chance to make that video :)

[@amgdhussein7040]

can you please do more videos for SQLs intermediate problems ?

[@thecodingmentor7701]

Hi Amgd, Im working on a big video that also includes lots of intermediate problems. Subscribe and keep notifications on so you don't miss it :)

[@dharmaputra7394]

Can you explain more about subquery i need to learn about that

[@thecodingmentor7701]

Maybe more in future videos. I can also recommend WITH statement to you. It can do everything that the subquery can do and it is easier to read for other people that use your code

[@shubhammaurya9743]

I would need your help in shorting a code am stuck anyhow and not able to clear may be you can help me out.
Wasn’t able to find your email please share so I can share the question

[@thecodingmentor7701]

You can send it to [e-mail] and I will take a look at it