Meta SQL Interview Question| Acceptance Rate by Date #dataanalytics #dataengineering #sql #meta

In this video, we will solve the SQL Medium Level interview question asked in Meta

SQL Script:
CREATE TABLE UserActions (
user_id_sender VARCHAR(50),
user_id_receiver VARCHAR(50),
action_date DATE,
action VARCHAR(20)
);

INSERT INTO UserActions (user_id_sender, user_id_receiver, action_date, action)
VALUES
('ad4943sdz', '948ksx123d', '2020-01-04', 'sent'),
('ad4943sdz', '948ksx123d', '2020-01-06', 'accepted'),
('dfdfxf9483', '9djjjd9283', '2020-01-04', 'sent'),
('dfdfxf9483', '9djjjd9283', '2020-01-15', 'accepted'),
('ffdfff4234234', 'lpjzjdi4949', '2020-01-06', 'sent'),
('fffkfld9499', '993lsldidif', '2020-01-06', 'sent'),
('fffkfld9499', '993lsldidif', '2020-01-10', 'accepted'),
('fg503kdsdd', 'ofp049dkd', '2020-01-04', 'sent'),
('fg503kdsdd', 'ofp049dkd', '2020-01-10', 'accepted'),
('hh643dfert', '847jfkf203', '2020-01-04', 'sent'),
('r4gfgf2344', '234ddr4545', '2020-01-06', 'sent'),
('r4gfgf2344', '234ddr4545', '2020-01-11', 'accepted');

Easy - Level questions -
https://youtube.com/playlist?list=PLP8zk3fCtbPIRr92ZlRnw6H__IgWQdetg&si=-HgJ2ZeVg1IL35f3

Medium - Level questions -
https://youtube.com/playlist?list=PLP8zk3fCtbPI6zpFi9-BENOuzCtUpMUwe&si=O1m4aK2fupBozHNt

Hard-Level SQL interview questions -
https://youtube.com/playlist?list=PLP8zk3fCtbPK-D8N_jInxlPNaDdlwEjHJ&si=gHH5avPPSunyM6Jx

If you have any interesting SQL questions, feel free to send them to me at
kulkarnisneha891@gmail.com.



#sqlserver #dataanalytics #dataanalyst
#sqlqueries