Скачать или смотреть Tricky SQL without JOIN Operation🔥 EXISTS For LOOKUP SubQuery !!

⭐ Subscribe to Hindi Channel -    / @datawalebhaiya219  
🔴 Book Free Trial, Job Guaranteed SDE Course - https://bit.ly/3C0ceSx
🔅 Follow Me On Instagram -   / _shashank_219  

𝗝𝗼𝗶𝗻 𝗺𝗲 𝗼𝗻 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:🔥
🔅Shashank LinkedIn -   / shashank219  
🔅Shashank Instagram -   / _shashank_219  
🔅Telegram Group - LearningBridge
⭕Discord Server - https://discord.io/shashankELB
🔴Join for 1x1 Mentorship, Mock Interviews, Career Guidance, Resume Building, Interview roadmap and resources to crack tech, BigData/Data Engineering tutorials from scratch :
   / @shashank_mishra  


𝗗𝗶𝘀𝗰𝘂𝘀𝘀𝗲𝗱 𝗤𝘂𝗲𝘀𝘁𝗶𝗼𝗻𝘀:

✅ 0:00 -- Inside This Video
✅ 1:26 -- Problem Statement for SQL Question
✅ 5:09 -- Job Guaranteed SDE Courses
✅ 6:59 -- Solution EXISTS vs JOINS

===========

create table customers ( customer_id int, customer_name varchar(100), customer_email varchar(200), primary key (customer_id) );

insert into customers values(1,'Shashank','[email protected]');
insert into customers values(2,'Rahul','[email protected]');
insert into customers values(3,'Ajay','[email protected]');
insert into customers values(4,'Nitin','[email protected]');
insert into customers values(5,'Naveen','[email protected]');

create table orders ( order_id int, customer_id int, amount float, status varchar(50), primary key (order_id) );

insert into orders values(101,1,550,'Delivered');
insert into orders values(102,2,350,'Delivered');
insert into orders values(103,1,220,'Cancelled');
insert into orders values(104,3,660,'Delivered');
insert into orders values(105,3,300,'Delivered');

=============



#sql #datascience #interview