commit d18ba73880ce7207168739d0e0fa1237cb2e9d6b parent b6762a17d18cc8e0288db8a0fccc5a44a9102d93 Author: AndrewLockVI <andrewlaack1@gmail.com> Date: Mon, 3 Jul 2023 07:01:53 -0500 Completed customers who visited without transactions using mySQL' Diffstat:
| A | customer-who-visited-but-did-not-make-any-transactions/customer-who-visited-without-transaction.sql | | | 10 | ++++++++++ |
1 file changed, 10 insertions(+), 0 deletions(-)
diff --git a/customer-who-visited-but-did-not-make-any-transactions/customer-who-visited-without-transaction.sql b/customer-who-visited-but-did-not-make-any-transactions/customer-who-visited-without-transaction.sql @@ -0,0 +1,10 @@ +--Given a list of customer visits and purchases +--return all customers who did not make any purchases +--at a given visit and how many times each did that. + +SELECT Visits.customer_id, COUNT(Visits.visit_id) as count_no_trans +FROM Visits +LEFT JOIN Transactions +ON Transactions.visit_id = Visits.visit_id +WHERE Transactions.transaction_id is NULL +GROUP BY Visits.customer_id