You work as a Database Administrator for Domain.com. The company uses MySQL as its
database development platform. You have created a table named Employees in the database.
You are assigned the task to create a report that will contain the first name of employees who are
working as Marketing Managers for the organization.
The structure of the table is as follows:
Which of the following statements will you use to accomplish the task?
A.
SELECT First_name FROM Employees WHERE Desig_id = ‘Mar_man’;
B.
SELECT First_name FROM Employees WHERE Desig_id = Mar_Man;
C.
SELECT First_name FROM Employees HAVING Desig_id = ‘Mar_Man’;
D.
SELECT First_name FROM Employees WHERE Desig_id = ‘Mar_Man’;