Question 6.1 How many counties in California had a 2010 population of more
than 500,000 persons?
There were 16 counties in California with a population exceeding 500,000
individuals.
Question 6.2 How many counties in California had a 2010 population of less
than 50,000 persons?
California had 15 counties in 2010 with a population below 50,000 individuals.
Question 6.3 How many counties in California had a 2010 population of more
than 50,000 persons but also fewer than 100,000 persons?
Question 6.4 What is the combined total 2010 population of these three
counties?
The combined population of these three counties in 2010 amounted to
15,924,150 people.
Question 6.5 Why did you use OR instead of AND as the Boolean connector
between the queries each time? How would the results have been different if
you had used AND instead of OR each time in this compound query?
To utilize the OR connector is more appropriate than AND in this scenario.
Searching for counties by specific names like Los Angeles OR San Diego, that
correctly seeking either the county named Los Angeles, or the county named
San Diego instead of a single county named Los Angeles San Diego.
Question 6.6 How many points are in the Fire Stations layer?
Total of 4,316 points.
Question 6.7 How many points are in the Hospitals layer?
564 points.
Question 6.8 How many fire stations are in Ventura County? How many fire
stations are in Sutter County?
There are 80 fire stations in Ventura Country, and in Sutter County there are 15
fire stations.
Question 6.9 How many hospitals are in Ventura County? How many fire
stations are in Sutter County?
Ventura County is home to 12 hospitals, while Sutter County has 2 fire stations.
Question 6.10 In what county is the Yurok Volunteer Fire Department located?
Located in Humboldt County.
Question 6.11 In what county is Ukiah Valley Medical Center located?
