HACKER RANK (SQL PROBLEM) CHALLENGES | URDU / HINDI

#coding #challenges #SQL #Hacker_Rank #Problem_Solving #Urdu #Hindi #Solution #Education_Hub_Online #Education #sql_server
In this video, we have solved the HACKER RANK (SQL Problem Question) CHALLENGES | URDU | HINDI.

[@AkashKumar-hg1is]

You explained really well,
how do you get the input values of table to use it in you local studio
because it takes a lot of extra useless effor to create and insert table values manually
thanks

[@pandeyRaman]

how did you imported the table values in local machine? pls tell...

[@noumanmunir3166]

There are two things:
1- The DISTINCT isn't needed at all, as after clause having count(c_compare) = 1 , there remains nothing to filter for distinct.
2- I didn't get the 'OR' thing, because 'OR' is equal to = one of them, If one condition is true it will return the result, and if the first condition is true it won't check the second one, in our case first Having 'c_max' condition is true, because query did find the ' top 1' challenge_id , then why the second condition is getting executed? Isn't it should be returned after the first condition? And If we want both conditions to be executed, shouldn't we use AND instead of OR, but when I use AND, It reruns ' no response'. Please explain this!.

[@dhruveshgaming4215]

In or if one condition is true will return true not checking the second condition. So the first part is to get max count and there can be multiple max count so by using max if there exist 2 max count they are valid and the second condition is only used when we get count less than max

[@noumanmunir3166]

@@dhruveshgaming4215 We have used the ' top 1' , how can there be multiple max counts?