Real SQL Interview Questions and Solutions for FAANG Interviews | Data Talks with Kat

If you are currently preparing for your next DS interview, or you want to know what SQL questions could be asked in a FAANG (Facebook, Amazon, Apple, Netflix, and Google) interview, this is a MUST-WATCH video. I will simulate the real interview process using a role-play to help you understand the questions you can expect in these interviews, the right questions to ask the interviewer, and the tips to tackle them effectively.
Best of luck with your next DS interview. Let me know when you get the offer :)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Hi, I'm Kat Li. Welcome to my channel, "Data Talks with Kat," where I will share my own experience with data science and its applications. If that sounds like it could be helpful for you, please join me by subscribing to my channel.
Want more data science and programming tips? Use my link to sign up to Medium and enjoy full access to all the content: / membership .
You are also welcome to follow me on my Medium page @ / yilistats .
📧 Business inquiries: yilistats[at]outlook[dot]com.
The following are Amazon affiliate links. That means if you purchase through the links below, I will get a small % from Amazon, but there is no premium added to your purchase price. Thank you for your support :)
Main Recording Camera Panasonic LUMIX G9: amzn.to/3eqRcTJ
Portrait LUMIX G II Lens: amzn.to/3Qvg3mU
Webcam OBSBOT 4k Meet: amzn.to/3qfxKMj
Video Editing Laptop Legion 5 pro gen 7: amzn.to/3cQnVRU
Green Screen: amzn.to/3RnXtOG
#SQL #datascience #interview #career #FAANG

[@DataTalksWithKat]

Please share your DS interview experience. What did you do well and what could be improved?

[@abstract_machine]

I think this is one of the best interview demo for faang sql process, thank you !

[@bryanstark324]

Thank you Kat for showing this demo. One reason that I know this was difficult to do is because I don't see it done on any other channels. I was wondering why you used a subquery instead of just using a simple AND statement instead of IN. We know IN is a decent substitute for OR but it's no substitute for AND.

[@bryanstark324]

I think the scariest thing about the interview is it looks like the hiring manager won't let you test run your query to see what data you get. Typically, I write some code, test it and see if I'm closer to what I want, then write more code and test that. It's more of an objective process rather than writing the code once, then optimizing then say I'm done.

[@DataTalksWithKat]

Hi Bryan, you are right, IN is a substitute for multiple OR conditions. A simple AND operator won't work because this dataset is a long/stacked data where all location values are organized in the same column; therefore, we'd need a counter to check each condition within each user.

[@DataTalksWithKat]

Exactly! In tech interviews, you only get to test your code after you have finished coding. Usually minor syntax errors are fine, but logic errors like we went through in the video are fatal.

[@meenayegan6634]

Hello
a small variation
count(*) - cal_count will give us the non_cal_count
count(*) - counyt null values as well

[@bhajans-m3l]

can u pls post the code for this sql table in the description box