Question

Construct a query statement that selects counties with a population greater than 100,000 but only when the median income is below $20,000 per year.

Answer 1

A SQL query to select counties with a population greater than 100,000 and a median income below $20,000 is: SELECT * FROM Counties WHERE Population > 100000 AND MedianIncome < 20000;

Step-by-step explanation:

To construct a query statement that selects counties with a population greater than 100,000 but only when the median income is below $20,000 per year, you would use a SQL statement that imposes both these conditions using the WHERE clause. An example of such a query might look like this:

SELECT * FROM Counties
WHERE Population > 100000 AND MedianIncome < 20000;
This statement will produce a list of all entries in a theoretical Counties database table where the Population column value exceeds 100,000 and the MedianIncome column value is less than $20,000, presuming that the income is stored in whole numbers, i.e., $20,000 as 20000.