8.The name and population of cities in California (CA) with a population less than 150,000 people (37 rows)
10.The name and area of parks that have an area less than or equal to 700 square kilometers and provides camping (21 rows)
11. The name, state, and population of all cities in Colorado (CO) or Arizona (AZ) (22 rows)
12. The state name, nickname, and sales tax from records in the state table in the "West" and "South" census regions with a sales tax that isn't 0% (26 rows)
13. The name, abbreviation, and population of all records in the state table with no official nickname (NULL) (5 rows)
14. The state name, nickname, and census region for states that start with the word "New" (4 rows)
15. The name, state abbreviation, and population for cities that end with the word "City" (11 rows)
16. The name, date established, and area of parks that contain the string "Canyon" anywhere in the name (5 rows)
17. The name, population, and area of all records in the state table with no census region (NULL) and area less than 5000 square kilometers (3 rows)
18. The name, population, and sales tax of all records in the state table with a sales tax of at least 7% or have a population of less than 1,000,000 (17 rows)
19. The name, population, area, and population density (name the column 'population_density') of all states, territories, and districts (56 rows)
-- Population density is expressed as people per square kilometer. In other words, population divided by area.
20. The name, population, area, and population density (name the column 'population_density') of states, territories, and districts with more than 100 people per square kilometer (12 rows)
-- Population density is expressed as people per square kilometer. In other words, population divided by area.
21. The name and nickname for all records in the state table with no official nickname (NULL) or nickname starts with the word "The" (13 rows)
22. The name and sales tax for states and territories with sales tax greater than or equal to 2% and less than or equal to 5% (15 rows)
23. The name and date established of parks opened in the 1960s (6 rows)