Graded Quiz: Refining Your Results

Graded Quiz: Refining Your Results >> Databases and SQL for Data Science with Python

SELECT lastname from author where lastname like ‘B#’

SELECT lastname from author where lastname like ‘B%’

SELECT lastname from author where lastname like ‘B$’

None of the above

Correct: Correct. You can use the % sign as a wildcard to indicate zero or more missing characters.

ORDER BY clause

ORDER IN clause

ORDER WITH clause

Correct: Correct. You use the ORDER BY clause to control the order of rows in the result set.

HAVING

WHERE

DISTINCT

All of the above

Correct :Correct. You can use all of these keywords to restrict a result set.

Graded Quiz: Refining Your Results >> Databases and SQL for Data Science with Python