Structured Query Language (SQL)

Question 1

Which SQL clause chooses which fields to display?

Accepted Answer

SELECT — SELECT lists the fields the query will show.

Question 2

Which clause states which table to read from?

Accepted Answer

FROM — FROM names the table the data is retrieved from.

Question 3

Which clause sets a condition that records must meet?

Accepted Answer

WHERE — WHERE filters the records to only those meeting the condition.

Question 4

Which clause sorts the results of a query?

Accepted Answer

ORDER BY — ORDER BY arranges the returned records into a chosen order.

Question 5

What does the query SELECT * FROM Members; return?

Accepted Answer

every field of every record — The * selects all fields and, with no WHERE clause, all records are returned.

Question 6

Which function counts the number of records?

Accepted Answer

COUNT — COUNT returns how many records match the query.

Question 7

Which function adds up the values in a numeric field?

Accepted Answer

SUM — SUM totals the values of a numeric field.

Question 8

Which condition selects records where Price is above 100?

Accepted Answer

WHERE Price > 100 — The greater-than operator selects prices higher than 100.

Question 9

To sort results from highest to lowest you use...

Accepted Answer

ORDER BY field DESC — DESC orders the records from the highest value down to the lowest.

Question 10

How should a text value be written in a WHERE condition?

Accepted Answer

in single quotes, e.g. 'F5A' — Text (string) values must be enclosed in quotes in an SQL condition.