Examine the description of the transactions table:

Which two SQL statements execute successfully?

See the Exhibit and examine the structure of the PROMOTIONS table:

Using the PROMOTIONS table,
you need to find out the average cost for all promos in the range $0-2000 and $2000-5000 in category A.
You issue the following SQL statements:

What would be the outcome?

View the Exhibit and examine the data in the PRODUCT_INFORMATIONtable.

Which two tasks would require subqueries? (Choose two.)

Examine the description of the CUSTOMERS table:

You need to display last names and credit limits of all customers whose last name starts with A or B in lower or upper case, and whose credit limit is below 1000.
Examine this partial query:

Which two WHERE conditions give the required result?

You must find the number of employees whose salary is lower than employee 110.
Which statement fails to do this?