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

# Write your MySQL query statement below
select
v.customer_id,
count(1) as count_no_trans
from visits v
left join transactions t
on v.visit_id = t.visit_id
where t.visit_id is null
group by 1