A question very similar to this was asked to me in one of the rounds of interviews at Meesho.
#data analyst #data science #sql
Table Creation Code(DDL):
CREATE TABLE Video_Reviews (
Video_ID VARCHAR(10),
Flag_ID VARCHAR(10),
Reviewed_by_YT BOOLEAN,
Reviewed_date DATE,
Reviewed_outcome VARCHAR(20)
);
INSERT INTO Video_Reviews (Video_ID, Flag_ID, Reviewed_by_YT, Reviewed_date, Reviewed_outcome) VALUES
('ABC', 'qwer', TRUE, '2021-01-01', 'REMOVED'),
('ABC', 'asdf', FALSE, NULL, NULL),
('DEF', 'zxcv', FALSE, NULL, NULL),
('GHI', 'tyui', TRUE, '2021-01-05', 'APPROVED'),
('GHI', 'ytrx', TRUE, '2021-01-06', 'APPROVED');
Interview Question(DML):
select concat(user_firstName, user_lastname),
Video_ID, count(distinct flag_id)
from User_videos
group by 1,2
16 окт 2024