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

/* Write your PL/SQL query statement below */
select customer_id, count(visit_id) as count_no_trans 
from visits
where visit_id not in (
    select visit_id
    from transactions
)
group by customer_id