Video 291: This is the 2nd video of the SQL Interview Question series.
00:00 - Introduction to dataset and Question
02:25 - Using Left Join and filter records
08:05 - Conclusion
We are given two tables Customers and Orders.
Customers table has customer_id and name of the customer
Orders table has order_id and the customer who ordered
We are asked to write a solution to find all customers who never order anything.
In this video, we are going to find all customers who never placed an order. We'll write an SQL query to solve this problem and return the result
For a comprehensive understanding of these SQL methodologies and their application, please refer to this explanatory video.
code: github.com/jeganpillai/adv_sq...
Follow me on,
Website : growwithdata.co/
KZfaq : / @growwithdata
TikTok : / growwithdata
LinkedIn : / growwithdata
Facebook : / growwithdata.co
FB Group : groups/datainterviewpreparation
twitter : / growwithdata_co
Instagram : / growwithdata.co
WhatsApp : whatsapp.com/channel/0029VaF8...
TheWide : thewide.com/profile/891
#sql #dataengineers #tablejoins #ceil #floor #bucket #meta #google #facebook #apple #paypal #netflix #amazon #deinterview #sqlinterview #interviewquestions #leetcode #faang #maanga #mysql #oracle #dbms #query #sqlserver #mysql #coderpad #aggregates #aggregation #nonaggregation #database #placementpreparation #lead #lag #windowsfunction #nullcheck #coalesce #sqlperformance #ifnull #case #lead #lag #windowsfunction #tamil #tamilpython #tamilinterview #tamilinterviewlatest #tamilinterviewquestions #sqlintamil