You’re designing a new SQL Server 2012 query for the HR department. The query will find records
from the persons table for people whose name starts with ‘Ja’. Which WHERE statement would be
the correct choice?

A.
where (name like ‘Ja%’)

B.
where (name = ‘Ja%’)

C.
where (name > ‘Ja’)

D.
where (name like ‘%Ja%’)