LeetCode_Study_Plan/SQL
1581. Customer Who Visited but Did Not Make Any Transactions mysql
개발하는루루
2022. 9. 30. 14:54
https://leetcode.com/problems/customer-who-visited-but-did-not-make-any-transactions
select v.customer_id, count(*) as count_no_trans from visits v left join transactions t on v.visit_id = t.visit_id where t.transaction_id is null group by v.customer_id;