Question

Add the criteria for the OpenDate field so that the query only displays accounts opened on or after 1/1/2011 with balances < ____.

a) $10,000
b) $5,000
c) $20,000
d) $15,000

Answer 1

To display accounts opened on or after 1/1/2011 with balances below a certain value, you need to use the greater than or equal to operator for the date criteria, and the less than operator for the balance criteria. Hence the correct answer is option A

Step-by-step explanation:

To add the criteria for the OpenDate field in the query, you need to use the greater than or equal to operator (>=) and specify the date '1/1/2011' in the criteria. Additionally, you need to use the less than operator (<) with the desired balance value to only display accounts with balances lower than that value. Let's assume the desired balance value is $10,000, so the criteria would be '>= 1/1/2011 and < $10,000'.

An example of the complete query would be:

SELECT * FROM accounts WHERE OpenDate >= '1/1/2011' AND Balance < 10000;

Hence the correct answer is option A