Data Analyst Interview Questions I SQL Interview Questions | SQL Interview Queries

Data Analyst Interview Questions
SQL Playlist: • Oracle SQL
Interview Preparation: / playlistlist=ploah_5_4...
Code: drive.google.c...
Keywords: sql interview questions,sql interview questions and answers,data analyst interview,data analyst interview questions,data analyst interview questions and answers,interview questions sql,data analyst,data analyst interview questions for freshers,sql interview questions for freshers,sql interview questions for experienced,sql interview questions and answers for freshers,sql interview,data analytics interview questions,sql interview questions for beginners

[@suhaschandras4318]

Awesome 👍

[@LearnwithPam-n5x]

@@suhaschandras4318 Thanks for watching

[@harshboda2922]

Very helpful video

[@LearnwithPam-n5x]

Thanks for watching

[@ATHARVSUTAR690]

Nice explanation

[@LearnwithPam-n5x]

Thanks for watching

[@50_maheshpatil57]

🔥🔥🔥

[@LearnwithPam-n5x]

Thanks for watching

[@malcorub]

Thank you for this video amigo! Is the WHERE a.team_no b.team_no really necessary? It seems like the following line with the < would be enough to ensure the row numbers are never equal.

[@LearnwithPam-n5x]

Thanks for watching. The answer for your question is as per requirement one team should play with other team only once (IND-AUS but not AUS-IND). So thats why we need to use above condition. And Yes < can be also possible. You can check at your end also.

[@malcorub]

@@LearnwithPam-n5x I will try it out. Thank you for your response. Keep up the great work!

[@ushasworld5223]

My small request could u please zoom in the query ur writing please because its so hard to seed

[@LearnwithPam-n5x]

Yes sure, for next video I will zoom into screen. Thanks for watching.

[@prabhatgupta6415]

bhai data bhi provide kr diya kro

[@LearnwithPam-n5x]

Yes uploaded. Check in Description box. Thanks for watching.

[@AbhijitPaldeveloper]

Second question query answer in mysql- SELECT result, ROW_NUMBER() OVER(ORDER BY result) as `groups` FROM(SELECT GROUP_CONCAT(id,name) as result FROM(SELECT *, ROW_NUMBER() OVER(PARTITION BY ID%2) as part FROM `group` ORDER BY name ASC) as e GROUP BY part ORDER BY part ASC) as e1

[@Shriramkrishnhari]

If you can explain in Hindi language will be more better...

[@LearnwithPam-n5x]

Yes. I will try.

[@Shriramkrishnhari]

@@LearnwithPam-n5x thanks, Your efforts are appreciatable Beginner friendly...

[@Shanmugamanickavel]

Pam bro do u take private classes on query writing?? Also how do we know to use ntile and listtag ?? Please explain

[@LearnwithPam-n5x]

No I don’t take private classes. But if you want I can create a separate video on that.

[@ATHARVSUTAR690]

Great video sir. Thank You ❤

[@LearnwithPam-n5x]

Thanks for watching