Apply your comprehensive GIS expertise and the knowledge acq…
Apply your comprehensive GIS expertise and the knowledge acquired throughout this course to identify counties in your state eligible for winter heating assistance grants. You have been tasked with determining which counties are eligible using criteria the Department of Health and Human Services have designated to identify at-risk counties. These criteria are: · Median household income must be less than $25,000 per year, and · The population of elderly (age 65+) must be over 200,000, or · The population of children (age 17 and below) must be over 100,000 Your variables are: [MED_INCOME] [AGE_65+] [UNDER_18] Construct a detailed selection query using the specified variables and set/Boolean algebra operators. Include parentheses to explicitly define the order of operations, resulting in a query that accurately identifies the target counties.
Read Details