SQL interview questions and answers | Entry level data analyst interview

For the last problem, wouldn't it make sense to include "GROUP BY name" at the end of the query, since an actor could have appeared in multiple movies with Art Garfunkel, causing them to be listed multiple times?

That didn't happen in this case, so the solution is correct either way, but if you take out the "AND name != 'Art Garfunkel'" at the end, his name shows up three times in the output, one for each movie he was in, so this would be a problem if an actor appeared in multiple movies with him.

Amazing video! Many thanks!

Yooooh, I'm typing your questions in chatGPT and it giving me the same answers without event presenting it with tables. This is awesome

Thanks Aaron, really good and clear tutorial!

Loved it. very useful. highly recommended.

There are three join types - INNER, OUTER and CROSS, not four. You missed the latter one. And you missed FULL OUTER join. Also LEFT, RIGHT and FULL joins are different kinds of OUTER join.

Great video, thanks!

Wow!!!! I just had a 1st round interview for an entry-level Data Analyst position and just received an update back from the recruiter for a 2nd round interview that I am currently preparing for. Thank you so much for this video. It really helped me to understand how to create proper SQL queries I am currently learning from DataCamp.

Thanks for this video.

Definitely subbed. Definitely a fan now. Please do more videos in your calm and clearly structured manner. Thanks!

Big up yourself

sir, can you please upload a video on how to work on SQL from an excel data project. can you please show a demo project? @AaronMOliver

Lovvvvvve it make more like these

Thank you 🙏

Thanks for sharing your knowledge, was really helpful. Just a quick question: is it common to alias without writing the AS statement?

cte would be better for last question

the music was a nice touch and helped me stay focused. Keep doing what you are doing bro. thanks

this is great

And there are gap's

Hey Aaron can you tell me where I can find the practice sql question except hackerrank

Straight to the point and simplified... very interesting 👌 👍

Ty! I’m applying for my first data analytics job and this help me verbalize topics that I knew but didn’t know how to say 😅

so helpful and calming rather than overwhelming

Thanks so much .. great and relevant content

Hi, thanks for the video!
Where do you get these questions? (I went to the SQLzoo site and couldn't find questions) I would be happy if you can send me a link! Thanks

The music is distracting bro, great vid but litterally if it's a education video then make it raw, you don't need to make entertaining as in putting in music. Thanks for the info tho 🙂

nice video! I will have junior data analyst tech interview next week , and the interviewer said he will give me a case study and test my sql and powerBI skill, I have no idea how it could be. do you have any suggestion for data analytics case studies?

bro im trying to be an analyst and im learning pandas, sql, python, tableau, matplotlob and I think this is too much. i didnt know interviews will just ask me simple things like sql