Hi bro is there any criteria while joining these tables . Because i ve choosed first table as hackers table nd then chllngers table . Finally ive got wrong answer.
@@amitavaghosh383 Thanks amitava In this query, s.score = d.score AND c.difficulty_level = d.difficulty_level Will return only those rows who earned full score of that challenge, right?
Very nice 👍👍👍👍
Hi bro is there any criteria while joining these tables . Because i ve choosed first table as hackers table nd then chllngers table . Finally ive got wrong answer.
But how to check whether he got full score or not according to difficulty level
There is one difficulty table where the highest score is mentioned for each difficulty level. From there u can check if he got full score or not
@@amitavaghosh383 Thanks amitava
In this query, s.score = d.score AND c.difficulty_level = d.difficulty_level
Will return only those rows who earned full score of that challenge, right?
More explanation should be given in the video. Anyways Thanks!
having clause, i missed it!
Nice dada
Really good work ❤️...