MiniCorp wants to track how their stores are doing by region. In order to do so, they added two new tables to their SQL database. The first table is called REGIONS and stores the name and ID of each region. The second is called STOREREGIONS and indicates which stores are in which regions.
You are beginning to explore these tables and you run the following queries with the results shown:
SELECT r.name, count(s.store_id) FROM storeregions s, regions r WHERE s.region_id = r.regionid GROUP BY s.region_id;
North 156
South 591
East 302
Southwest 208
Northwest 396
SELECT COUNT(DISTINCT store_id) FROM storeregions;
956
What can we conclude?