Hackerrank SQL Solutions | Challenges SQL Hackerrank Intermediate Problem

[@rayyanamir8560]

I like the way that you don't directly put the solution but instead choose to show step by step procedure

[@thecodingmentor7701]

Thanks, I hope you can learn as much as possible from it :)

[@rayyanamir8560]

@@thecodingmentor7701 Thanks. Could you do leetcode sql problems as well?

[@divyanshisharma4054]

Very awesomely explained. I absolutely loved it and didn't find a single channel explaining things in such minute detailing. Kudos to you, thanks a ton :)

[@shouvikmandal8926]

Many many thanks to you. Your step by step explanation of forming the query helped to me understand this complex question.

[@nishantvohra1537]

Just Wow. Its so great how you explain it step by step. worth every single minute.

[@gowtham0101]

Thank you my brother, you have great patience

[@dramaticreviews6278]

Excellent piece of work

[@rahultalwar4847]

nicely explained sir, Thank you🤩

[@mohdfaiz6885]

Thank you very much man after spending hours reading it was quite blurry but you explained it quite well within a few minutes cheers to you

[@thecodingmentor7701]

Thanks mohd, glad I could help you out!

[@MohamedMagdy-00]

You know how to teach !! Many Thanks

[@jagatheeswariravi8686]

Oh. Bro.. Finally i understood..Thanks

[@Pr3kashSingh]

thank you very much . I was struggling in it for long .

[@thecodingmentor7701]

Glad it helped!

[@harichandana2260]

This is brilliant..

[@MohanLal-lw7dd]

Very very brilliantly explained. Thanks brother for making it easy for us...

[@thecodingmentor7701]

Thanks for your positive comments Mohan! Im glad you liked it

[@paragrehani6901]

Very Nicely explained!! Thank you so much.

[@thecodingmentor7701]

Thanks Parag. I'm Glad it was helpful!

[@diftq8191]

My hero

[@stevenzambrano6628]

Brilliant ! When will we get the symmetric pairs question?

[@thecodingmentor7701]

Hi steven, thanks! It will take some weeks but in that time, enjoy the other sql hackerrank solutions ;)

[@swarajmehta3011]

thank you for this explaination

[@thecodingmentor7701]

You're welcome Swaraj!

[@maitrayirajawat697]

thank you this helped me.

[@anishchhabra5313]

Thank you so much. You are great.

[@thecodingmentor7701]

You are too Anish! Thanks for your comment :)

[@vivekjoshi3769]

Wow this is much clear than the other solution I saw on discussion. Hey I have a question. These questions are filed under 'Medium' problems. So far out of 5 'Medium' problems I was able to solve only 2 & on other 3 despite spending more than 2 hours I got frustrated till the point where I felt I would fail if this level of question comes in the technical round of Database Engineer interview. What do you advice about how much time should I spend on one problem? I think 2 hours is too much + it creates a feeling of demotivation in me. Also do you do free 1:1 sessions(cannot pay at the moment but it's fine if you do only paid ones 😅) or if you on discord? I would like to connect and ask more. I am a career transitioner aiming to get better at SQL and get a job in data domain but it's a rough time for me. Would appreciate any way I could connect(ofc if you are ok)

[@thecodingmentor7701]

Hi Vivek, thanks for your comment. I dont find 2+ hours to solve a Problem too bad. It took me oftentimes as long as that to solve problems. Maybe take some breaks in between and go for a walk, get some fresh air, it helps your brain. I also made a video on solving hard problems, that you can watch. I dont do free 1:1 sessions but you can connect with me on LinkedIn (Video description). I also recommend keeping your profile on LinkedIn updated and share your progress there on your journey to get into the data domain.

[@LiveLikeAButterfly]

Thanks for posting this..

[@shubhamgandhi7071]

Thanks for posting this. Indeed very helpful. I ran the same code in MySQL and it is throwing some error. Can I use the With statement in MySQL?

[@thecodingmentor7701]

Yes, absolutely. You can use with Statement in MySQL. Find it here: dev.mysql.com/doc/refman/8.0/en/with.html

[@dimmak8206]

@@thecodingmentor7701 Thanks for the great video, can you adjust the code so that it work in MySql, seems to not accep the With Clause

[@HuyHuy-wy6vi]

thanks you

[@alishadeb457]

The question says "If more than one student created the same number of challenges AND the count is less than the maximum number of challenges created". Can you explain why did you put keyword ""then" instead of AND between these two statement?

[@thecodingmentor7701]

Hi alisha, you are probably referring to my notes on the right side in line 18 where I write then. You are correct, it should say AND in that line. Thanks! :)

[@swaradalele9637]

Can u plz give solution for sql intermediate for certification

[@thecodingmentor7701]

Hi Swarada thanks for your comment! Im currently studying myself a lot and cannot make videos. But I will pick it up again after my exams. Greetings

[@ATNK1231]

dont go for certificate go for knowledge

[@thecodingmentor7701]

Hi swarada Its available now: kzbin.info/www/bejne/d5e3gYd9ibWdb6c&ab_channel=TheCodingMentor

[@peaceandlov]

wow

[@diftq8191]

Does anyone know why this doesn't work with MySQL? The error is: ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'tbl_num_challenges as ( SELECT h.hacker_id, h.name, COU' at line 1

[@thecodingmentor7701]

Hi Diftq, can you post the complete code where you get the error? It is not enough information to see whats wrong, thanks!

[@harleenkaur1200]

@@thecodingmentor7701 I am getting the same error, its not working well with MYSQL

[@harleenkaur1200]

ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'tbl_num_challenges as ( SELECT h.hacker_id, h.name, COU' at line 1

[@harleenkaur1200]

would be grateful for your response on this