distinct count by email

PHOTO

Mon Mar 10 2025 20:51:02 GMT+0000 (Coordinated Universal Time)

SELECT emailaddress, COUNT(*) AS count

FROM [w170049_newsletters_journey_ALL]

GROUP BY emailaddress

HAVING COUNT(*) > 1