วีดีโอ

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

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!.

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

sir can you please tell how did we define the sequence of Join?

Nice explanation.. Thanks for sharing

Thank you so much bro ✌️

Great bro

BEST😍

I want to you made up like this video with like this explanation👍👍

good explanation thanks

sonunda

I think this approach is more complex than simple join based approach.

Bhai video banate time to load bol liya kro. esa lag raha hai sirf man me badhbadha rahe ho. Dislike for this time.

Can you explain how come select min() function in this case can take all min values but not only 1 minimun value of the whole table?

can anybody explain why "where a.power=al.power and b.age=bl.age" was required in the query?

Best explanation to this problem.

Instead if writing another select statement, why can't we just order by coins needed asc

Hi.. Thank you for uploading the video. I have a doubt why we have converted the salary in float in sql server and if we write the same quote in mysql we need not convert it to float.. Please reply

Hi, This code gives an error, it works for MS SQL Server but gives syntax error for MySQL ... WTH is wrong lols SELECT Doctor, Professor, Singer, Actor FROM(SELECT ROW_NUMBER() OVER (PARTITION BY OCCUPATION ORDER BY NAME) as RowNumber, * FROM OCCUPATIONS) as Temp_Table PIVOT ( MIN(Name) FOR Occupation IN (Doctor,Professor,Singer,Actor) ) as Pivot_Table; 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 '* FROM OCCUPATIONS) as Temp_Table PIVOT ( MIN(Name) FOR Occupation IN (Doct' at line 2

bhai challenges and difficulty tables ko join karne ki kya zarurat ti

Clearly explained with logic and individual line output.

what is ( al )

AWESOME

Very nice explaination thank you

Specially 18

Sir isme 18,4 ka matalab kya h

I'm a beginner so just want to clearify my doubt . you have taken "select min(coins_needed) from wands" for min coins, it will give min among all but we have to take min for each non_evil category as per the example mention in que also it's mention that power and age should be higher so what's the meaning of using a.power=al.power and b.age=bl.age Can you help me in my doubts?

My solutions are the same but it's not working on SQL. Could you tell me why? I tried to solve it another way but didn't catch it up. So, please if you could have time then give us an idea. Thank you.

Why did you use MIN(NAME) in the query?

This is a great video and I'm so thankful! Just turn your microphone up and you'd be helping so many people so much better!

is there no way to solve this without pivot ?

Great step by step explanation

IF executing in my sql throughing Error but in MS sql Server executed successfully, Can anyone Explain plz

SELECT ROW_NUMBER() OVER (PARTITION BY occupation ORDER BY name) AS [RowNumber],* FROM occupations; Gives me an error: SQL0104N An unexpected token "AS" was found following "ation ORDER BY name)". Expected tokens may include: "<space>". SQLSTATE=42601 How do I solve it??

omg thank you. this video very succesful. I m very search this video and ı got it. thank you so much :)))))

God bless you 🤠

Keep it up

Nice information sir

check

Best

Amazing

Nice 👍🏻

Best of luck

Very good

10 done bro