Cacher is the code snippet organizer for pro developers

SELECT address_type,
       customer_id,
       count(concat(customer_id, address_type)) AS cnt
FROM customer_address
GROUP BY address_type,
         customer_id
HAVING cnt > 1;