1581. 进店却未进行过交易的顾客
题目链接:1581. 进店却未进行过交易的顾客
代码如下:
# Write your MySQL query statement below
select customer_id,
count(customer_id) as count_no_trans
from Visits v
where Visit_id not in (
select distinct visit_id from Transactions
)
group by customer_id