Option A

Option B

Option C

Option D

SELECT DISTINCT last_name, first_name FROM people

SELECT 1,2 FROM people GROUP BY last_name

SELECT first_name, last _name FROM people WHERE age LIKE ‘2’

SELECT 1, 2 FROM people WHERE last _name =’smith’

SELECT first _name, last_name FROM people LIMIT 1, 2

A view created with the TEMPTABLE algorithm

A view containing a GROUP BY clause

A view containing a WHERE clause

A view containing a HAVING clause

A view that contains a literal column