CIW Exam Questions

You need to apply a SQL statement to the Recreation relation that will return the following data:

Consider the Recreation relation shown in the exhibit. You need to apply a SQL statement to the
Recreation relation that will return the following data:

Which SQL statement applied to the Recreation relation will return this data?

A.
SELECT Activity FROM Recreation;

B.
SELECT DISTINCT Activity FROM Recreation;

C.
SELECT Activity FROM Recreation
WHERE NOT LIKE Activity;

D.
SELECT Activity FROM Recreation
WHERE DISTINCT Activity;