Review the SQL below and check all answers that are correct with

respect to the SELECT statement:

CREATE TABLE Customer$($

customer$\_$id DECIMAL $(6),$

first$\_$name VARCHAR$(30),$

last$\_$name VARCHAR$(30)$

;

SELECT customer$\_$id$,$ first$\_$name, last$\_$name

FROM Customer

WHERE last$\_$name IN$(\text{'}$Smith$\text{'},$'Jones','Salk'$)$;$"$

The query will never return any rows, no matter what data is in the

CUSTOMER table

The query will return no rows, because a last$\_$name cannot be both

'Smith', 'Jones', and 'Salk'

We cannot determine how many rows the query will return

The query will return exactly $6$ rows

The SELECT statement is not syntactically correct