How_to_code_subqueries/exercise_6.sql

SELECT vendor_name, vendor_city, vendor_state
FROM vendors
WHERE CONCAT(vendor_state, vendor_city) NOT IN (SELECT CONCAT(vendor_state, vendor_city) AS vendor_citystate
FROM vendors
GROUP BY vendor_citystate
HAVING COUNT(*) > 1);