You work as a Database Administrator for Domain.com. The company uses MySQL as its database.
You have created a table named Employees in the database. The table contains the following information:
You want to display information about employees in the following format:
First_Name, Last_Name, City
Which of the following statements will you use to accomplish the task?
A.
SELECT CONCAT(‘First_Name’ || CONCAT(‘ Last_Name’, ‘City’)) FROM Employees;
B.
SELECT CONCAT(‘First_Name’ || Last_Name’ || ‘City’)) FROM Employees;
C.
SELECT CONCAT(‘First_Name’, ‘ Last_Name’, ‘City’)) FROM Employees;
D.
SELECT CONCAT(‘First_Name’, CONCAT(‘ Last_Name’, ‘City’)) FROM Employees;