Question

You create the following query to determine whether Sample Movie appears only once in the Movie table

SELECT Title

FROM Movie

WHERE Title 'Sample Movie'

ORDER BY Title

GROUP BY Title

HAVING COUNT(*) = 1

When you run this query, it returns a syntax error.

You need to modify the query to run without error and return accurate results.

What should you do?

A Remove the GROUP BY clause

8 Remove the ORDER BY clause

C. Change the HAVING clause to HAVING COUNT(1) = 1

D Change the HAVING clause to HAVING COUNT(Title) = 1

Answer 1

Answer:

sorry I didn't know answer