Top 10 most common SQL queries | SQL Interview Questions For Data Science | CampusX Live 1

This is part 1 of a 3 part live lecture series on SQL Interview Questions for Data Science
Download data

[utkar]

@07:35 - Start
@11:52 - Common questions

[sid_x_]

in question 8 we could simply do SELECT name, genre, score FROM movies GROUP BY genre HAVING Max(score) ;

[tushartiwari]

At 27:00 there for second highest value query, there is another movie with 8.9 rating.
It is not included in the result.
The below query would handle this case.
SELECT * FROM movies WHERE score = (SELECT score FROM movies ORDER BY score DESC LIMIT 1, 1)

[uditbhaskar]

I revised through this series and cracked a product based company. Thank you so much sir

[binarystar]

One of the best channel to learn about Data science technology ✨ Nitin you try to explain things with your best effort and make it so simple to understand ❤️ Many thanks for such valuable contents ✨

[anshvashisht]

1:02:21 group by genre, score and then order by score desc limit 1

[shwetarawat]

One of the best channels for SQL, learned a lot thanks :)

[pravinshende.DataScientist]

sir your content is always awe some, , , when i come here to learn something to learn i become fully satishfied with the kowledge whick you deliver in a very simple laguage .. and your vidios has always a practical tone .. thank you!

[paragvachhani]

Sir bhahot hi samj aaya....
Sir, aisa laga ki ek non CS Student also play with data ad these all game....i so like it...sir

[lukechugh]

With CTE as (select *, row_number() over(partition by col1, col2, ... col n order by null) as rn from table)

Delete from cte where rn > 1;

[KaranSingh-hxdh]

If you make play list of SQL like machine learning. It will be very helpful.

[PreetiSoni-ce]

Awesome way of teaching sql query building techniques. Thank you so much

[ashwinshetgaonkar]

for second question: when additional column was added with NOT NULL constraint the table after that had null values in those columns for the existing data.

[KaranSingh-hxdh]

Sir, very nice. I am in very much need of SQL real live project. And working.

[beingcheercool]

Thank you very much sir 😊
You are my big brother 💝

[killshot]

2nd lowest rated -
Select * from movies order by scores asc limit 2, 1

[shantanu]

first and secound question add multiple rows rahega sir column nhi kyu ki rows horizontal mai arheta hai aur column vertical

[not_amanullah]

it feels so good when your subscribers are increasing ❤️

[amLife]

Sir, The way you teach us is just Amazing!! Thank you soo much!! May your channel achieve more and more milestones and reach millions very soon!!

[kali]

your all of the videos deserves a like