DAY 19 ||SQL Series| LeetCode SQL 50 || Day 2 | SQL Query to find Find Customer Referee||consistency
@CodeWithPoojagupta
🎥 Welcome to Day 19 of our SQL Series!
🌟 Day 2 of the "50 Days of SQL LeetCode Challenge"!
Hey everyone! 👋
Welcome back to Code With Pooja, where we explore coding concepts step-by-step to boost your programming skills. In today's video, we will solve a fascinating SQL problem from LeetCode: "Find Customer Referee" (LeetCode 584).
In this problem, we'll write a query to find the names of customers not referred by the customer with id = 2, including those who were not referred by anyone (i.e., referee_id IS NULL). 🛠️
✨ Key Concepts Covered:
Filtering data with WHERE conditions.
Handling NULL values in SQL.
Writing clean and efficient SQL queries.
Here’s the solution:
sql
Copy code
SELECT name
FROM Customer
WHERE referee_id != 2 OR referee_id IS NULL;
🚀 What You'll Learn:
How to query data based on conditions.
Using logical operators (OR, !=, and IS NULL).
How to format and interpret SQL results efficiently.
💡 Join the Challenge:
We're diving into 50 Days of SQL on LeetCode, solving real-world problems every day to sharpen our skills. Don’t miss a single day of this journey!
📌 Why Subscribe?
If you find this video helpful:
✅ Like the video!
✅ Subscribe to stay updated with daily SQL and DSA videos.
✅ Share this series with your friends and coding community.
🔗 Follow Me:
LeetCode: @POOJAGUPTA11072000
HackerRank: @poojaguptargpv11
YouTube: @Code_With_Pooja
⚡ Let’s Learn Together!
See you in the next video for more exciting SQL solutions! 🌟
🎯 Today’s Quote:
"The more you practice, the luckier you get!" Keep learning, keep growing. 😊
#SQL #LeetCode #CodeWithPooja #DatabaseQuerying #CodingChallenge