Your application connects to a SQL Server database that contains a table called Employees with the following columns:
You need to write a query that selects all rows from the table where the EmployeeType value is either C or T. Which statement should you use?
A. SELECT * FROM Employees
WHERE EmployeeType LIKE ‘[CT]’
B. SELECT * FROM Employees
WHERE EmployeeType LIKE ‘[C-T]’
C. SELECT * FROM Employees
WHERE EmployeeType LIKE ‘C’ OR ‘T’
D. SELECT FROM Employees
WHERE EmployeeType IN (‘C’, ‘T’)
D is correct