⭐ 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
Информация по комментариям в разработке