Customer Who Visited but Did Not Make Any Transactions.sql

select v.customer_id,count(v.customer_id) as count_no_trans 
from visits v 
where v.visit_id not in (select t.visit_id from Transactions t)
group by v.customer_id
order by count(v.customer_id);