SQL queries

Complete the following queries using the MAG USA geodatabase and the counties feature class. Rather than using tools like “Add to selection”, complete complex queries with one SQL statement.

1. Select counties where POP2014 is greater than 40000 and POP10_SQMI is less than 50. Note your SQL statement below.

2. Select counties where the ratio of FEMALES to MALES is greater than 1.1 or the MED_AGE is greater than 50

3. Select counties where one of the two conditions is fulfilled (i.e. an “or” clause):

• ASIAN is less than 1000 and BLACK is greater than 1000
• ASIAN is greater than 1000 and BLACK is less than 1000

3. Select counties where all three conditions are fulfilled:

• POP10_SQMI is less than 100
• The ratio of MALES TO FEMALES is greater than 1.1
• MED_AGE is greater than 55 or MED_AGE is less than 35