2025-08-06 16:26:47 +0000 UTC

Customer Who Visited but Did Not Make Any Transactions
Categories:
Tags:

Code

SELECT
    Visits.customer_id,
    COUNT(Visits.visit_id) AS "count_no_trans"
FROM
    Visits
LEFT JOIN
    Transactions
ON
    Visits.visit_id = Transactions.visit_id
WHERE
    Transactions.visit_id IS NULL
GROUP BY
    Visits.customer_id