SELECT count(DISTINCT LOCATION) FROM shop
Count the number of distinct store locations.
SELECT count ( DISTINCT LOCATION ) FROM shop
select count ( distinct location ) from shop
Count the number of distinct store locations .