REAL SQL Interview Question by a FAANG company | SQL Interview Query and Solution

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.

If you’d like to practice SQL queries or explore my recorded SQL courses, check out my all-in-one SQL learning platform, SQLNest 👇
https://sqlnest.com/

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-int...

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.

🔴 WATCH MORE VIDEOS HERE 👇

✅ SQL Tutorial - Basic concepts:
   • SQL Tutorial - Basic concepts  

✅ SQL Tutorial - Intermediate concepts:
   • SQL Tutorial - Intermediate concepts  

✅ SQL Tutorial - Advance concepts:
   • SQL Tutorial - Advance concepts  

✅ Practice Solving Basic SQL Queries:
   • Practice Solving BASIC SQL Queries  

✅ Practice Solving Intermediate SQL Queries:
   • Practice Solving INTERMEDIATE SQL Queries  

✅ Practice Solving Complex SQL Queries:
   • Practice Solving COMPLEX SQL Queries  

✅ Data Analytics Career guidance:
   • Data Analytics career and more  

✅ SQL Course, SQL Training Platform Recommendations:
   • SQL Course / Training  

✅ Python Tutorial:
   • Python Tutorial  

THANK YOU,
Thoufiq