REAL SQL Interview Question asked by a FAANG company

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.

So the question which you will find here is a real question asked by a FAANG company during an SQL interview. I want to thank my subscriber for sharing this query with me (not disclosing his name as requested by him).

I have explained in detail the solution that I came up with for this question in my YouTube video. Attaching this video below for your reference.

The SQL Question and the scripts to create the respective tables and the SQL Query to solve this question can be downloaded by clicking on the below two buttons. The downloaded SQL Query file will have SQL Query for PostgreSQL, MySQL, Oracle and Microsoft SQL Server (MSSQL) databases.