[solved] – Question 76379

What is the query below retrieving?

SELECT CUSTOMER_STATE

FROM CUSTOMER_T

GROUP BY CUSTOMER_STATE

HAVING COUNT(*) = 1

record for CUSTOMERID = 1

States with more than 1 customer

States with one customer

States with ID = 1

Expert Answer

---