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

https://leetcode.com/problems/customer-who-visited-but-did-not-make-any-transactions

select v.customer_id, count(*) as count_no_trans from visits v left join transactions t on v.visit_id = t.visit_id where t.transaction_id is null group by v.customer_id;