Chapter 3

Which clause of the SELECT statement specifies the table that contains the data to be retrieved?

FROM

Which of the following would return a maximum of 7 rows, starting with the 5th row?

LIMIT 4, 7

The order of precedence for the logical operators in a WHERE clause is

Not, And, Or

How would you code a SELECT clause so it returns all columns from the base table?

SELECT *

When you code a SELECT statement, you must code the four main clauses in the following order

SELECT, FROM, WHERE, ORDER BY

What is the result of the expression that follows if the value of last_name is "Smith" and the value of first_name is "Steve"?CONCAT(last_name, first_name)

SmithSteve

When you code a calculated value in a SELECT clause, the expression for the calculated value can include

arithmetic operators and functions only

When you code an ORDER BY clause, you can specify a

column name, alias, expression, or column number

Which of the following expressions does not compute 10% of the balance due if balance due is the invoice total minus the credit total minus the payment total?

invoice_total - credit_total - payment_total / 10

When coded in a WHERE clause, which search condition will return invoices when payment_date isn't null and invoice_total is greater than or equal to $500?

payment_date IS NOT NULL AND invoice_total >= 500

Which of the following is not a valid column alias?

total sales