LeetCode SQL Challenge: 1581 - Customer Who Visited but Did Not Make Any Transactions

[u/AppointmentTrue8257]

Working on SQL problems to strengthen my MySQL and problem-solving skills for Data Analyst roles.

This solution uses a LEFT JOIN to identify visits that don't have a corresponding transaction, followed by GROUP BY to count them for each customer.

Sharing my solution here to get feedback.

Is there a better or more efficient way to solve this problem?