SELECT count(DISTINCT LOCATION) FROM shop
How many different store locations are there?
SELECT count ( DISTINCT LOCATION ) FROM shop
select count ( distinct location ) from shop
How many different store locations are there ?