1581. Customer Who Visited but Did Not Make Any Transactions.md

1581. Customer Who Visited but Did Not Make Any Transactions

Question Link

Solution

# Write your MySQL query statement below
select v.customer_id, count(v.visit_id) as count_no_trans from Visits v
left join Transactions t
on v.visit_id=t.visit_id
where transaction_id is NULL
group by v.customer_id