Get free YouTube views, likes and subscribers
Get Free YouTube Subscribers, Views and Likes

PWC Data Analyst Interview | SQL Intermediate Question 11

Follow
Code-Con

Question Give review for the ids in the tables based on their occurrences in the tables.


DDL Commands
drop table sources;
drop table targets
create table sources(
sid int,
sname varchar(50)
);
create table targets(
tid int,
tname varchar(50)
);
insert into sources values(1,'A'),(2,'B'),(3,'C'),(4,'D');
insert into targets values(1,'A'),(2,'B'),(4,'X'),(5,'F');
select * from sources;
select * from targets;

#placement #placements #reels #dataanalytics #ml #facebook #instagram #interviewquestions #sql #google #amazon #flipkart #ml #ai #dataengineering

posted by afiguradatb