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?
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! :)
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 :)
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)
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.
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
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
Many many thanks to you. Your step by step explanation of forming the query helped to me understand this complex question.
I like the way that you don't directly put the solution but instead choose to show step by step procedure
Thanks, I hope you can learn as much as possible from it :)
@@thecodingmentor7701 Thanks. Could you do leetcode sql problems as well?
nicely explained sir, Thank you🤩
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?
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! :)
This is brilliant..
thanks you
Excellent piece of work
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 :)
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?
Yes, absolutely. You can use with Statement in MySQL. Find it here: dev.mysql.com/doc/refman/8.0/en/with.html
@@thecodingmentor7701 Thanks for the great video, can you adjust the code so that it work in MySql, seems to not accep the With Clause
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)
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.
Brilliant ! When will we get the symmetric pairs question?
Hi steven, thanks! It will take some weeks but in that time, enjoy the other sql hackerrank solutions ;)
My hero
Just Wow. Its so great how you explain it step by step. worth every single minute.
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
Hi Diftq, can you post the complete code where you get the error? It is not enough information to see whats wrong, thanks!
@@thecodingmentor7701 I am getting the same error, its not working well with MYSQL
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
would be grateful for your response on this
Oh. Bro.. Finally i understood..Thanks
Thank you my brother, you have great patience
You know how to teach !! Many Thanks
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
Thanks mohd, glad I could help you out!
thank you this helped me.
thank you very much . I was struggling in it for long .
Glad it helped!
Very very brilliantly explained. Thanks brother for making it easy for us...
Thanks for your positive comments Mohan! Im glad you liked it
Very Nicely explained!! Thank you so much.
Thanks Parag. I'm Glad it was helpful!
wow
thank you for this explaination
You're welcome Swaraj!
Thanks for posting this..
Thank you so much. You are great.
You are too Anish! Thanks for your comment :)
Can u plz give solution for sql intermediate for certification
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
dont go for certificate go for knowledge
Hi swarada
Its available now: th-cam.com/video/AfTPTGTPj9E/w-d-xo.html&ab_channel=TheCodingMentor