127. Databricks | Pyspark| SQL Coding Interview:LeetCode-1045: Customers Who Bought All Products

Description

Azure Databricks Learning: Coding Interview Exercise: Pyspark and Spark SQL ================================================================================= Coding exercises are very common in most Big Data interviews. It is important to develop coding skills before appearing for Spark/Databricks interviews. In this video, I have explained a coding scenario to find the customers who bought all the products available. This is also one of the common coding exercises asked in MAANG/FAANG/GAMAM companies such as Google, Apple, Microsoft, Amazon, Meta, etc. Consider the following tables: Products Table: +-----------+ |product_key| +-----------+ | 5| | 6| +-----------+ Customers Table: +-----------+-----------+ |customer_id|product_key| +-----------+-----------+ | 1| 5| | 2| 6| | 3| 5| | 3| 6| | 1| 6| +-----------+-----------+ Output: +-------------+ | Customer_Id | +-------------+ | 1 | | 3 | +-------------+ In this example, customer 1 and 3 bought all the products (5 and 6), so they are included in the output. Watch the video to understand the approach and …

Description from YouTube. Full content on the video page.