In this video, we shall see a REAL SQL Interview Question which was asked by a FAANG company (Facebook, Amazon, Apple, Netflix, Google). We shall explain how to solve this SQL Query step by step.
This SQL question was asked during an SQL interview process conducted by one of the tech giants (a FAANG company) recently.
Recently one of my subscribers, got a job in one of the FAANG companies (Facebook, Amazon, Apple, Netflix, Google) and he shared with me an SQL Questions which he was asked during his interview process. He wanted to know what my solution would be for this SQL question.
This SQL question is pretty complex hence in the video, we first try to understand the question and then try to build the logic which can be used to do the required calculation to arrive at the required output. Finally we start writing the SQL query from scratch to solve this question.
The SQL Question and all the SQL scripts and SQL Queries I have written in this video can be downloaded from my blog. You will also find the solution to this query in PostgreSQL, MySQL, Oracle and Microsoft SQL Server (MSSQL).
Link to my blog: https://techtfq.com/blog/real-sql-interview-question-asked-by-a-faang-company
Timestamp:
00:00 Intro
01:18 Understanding the SQL Question asked by a FAANG company
08:49 Building the SQL logic to solve the FAANG SQL Interview question
20:20 Writing the SQL Query for the FAANG SQL Interview question
Finally, a special THANK YOU to my subscriber who shared this SQL question with me (Not disclosing his name as requested by him).
If you found value from this video then please consider SUBSCRIBING to my channel and also appreciate a LIKE on this video.
More Videos:
Advance SQL Tutorial: https://www.youtube.com/playlist?list=PLavw5C92dz9GTiYtgpkhpK9GPx-r-JvSN
Practice SQL Queries: https://www.youtube.com/playlist?list=PLavw5C92dz9Eq4XcsdoSZiTKvOONVqsZv
SQL Interview Questions: https://www.youtube.com/playlist?list=PLavw5C92dz9FfTTdNYOkD15dJlvzoG1qc
Portfolio Projects: https://www.youtube.com/playlist?list=PLavw5C92dz9EmLDDQ7Nk5-IJhBQ7jUxxF
Python Tutorial: https://www.youtube.com/playlist?list=PLavw5C92dz9HIQOecVQRkuiFagBoyKV6z
Learn Git and GitHub: https://www.youtube.com/playlist?list=PLavw5C92dz9EI1MPlqqDpe3bgr8RJZE0b
SQL Basics Tutorial: https://www.youtube.com/playlist?list=PLavw5C92dz9GcaqGycSvnV8lfQLud6B_z
THANK YOU!