PWC Data Analyst Interview | SQL Intermediate Question 11

Описание к видео PWC Data Analyst Interview | SQL Intermediate Question 11

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

Комментарии

Информация по комментариям в разработке