8. Customer Who Visited but Did Not Make Any Transactions.
ฝัง
- เผยแพร่เมื่อ 11 ก.ย. 2024
- SQL 50 Problems - Leetcode SQL questions solution
Create table If Not Exists Visits_8(visit_id int, customer_id int);
Create table If Not Exists Transactions_8(transaction_id int, visit_id int, amount int);
Truncate table Visits_8;
insert into Visits_8 (visit_id, customer_id) values ('1', '23');
insert into Visits_8 (visit_id, customer_id) values ('2', '9');
insert into Visits_8 (visit_id, customer_id) values ('4', '30');
insert into Visits_8 (visit_id, customer_id) values ('5', '54');
insert into Visits_8 (visit_id, customer_id) values ('6', '96');
insert into Visits_8 (visit_id, customer_id) values ('7', '54');
insert into Visits_8 (visit_id, customer_id) values ('8', '54');
Truncate table Transactions_8;
insert into Transactions_8 (transaction_id, visit_id, amount) values ('2', '5', '310');
insert into Transactions_8 (transaction_id, visit_id, amount) values ('3', '5', '300');
insert into Transactions_8 (transaction_id, visit_id, amount) values ('9', '5', '200');
insert into Transactions_8 (transaction_id, visit_id, amount) values ('12', '1', '910');
insert into Transactions_8 (transaction_id, visit_id, amount) values ('13', '2', '970');
#leetcode #sql #data #dataengineers #datascience #dataanalytics #sqlinterviewquestions