Is there a way to do a DISTINCT on more than one col, say, customer_id and market, and then COUNT customer_id in the same statem

Question

Table has two columns
- Customer ID
- Market

Output Req: Unique list of Customer ID and Market. Then finally check if there are more than one record for a customer ID

Answer 1

SELECT market, COUNT(DISTINCT customer_id)... Group by market