Write a query against the EMPL table to show the names of all employees concatenated with their jobtypes.

Q. Write a query against the EMPL table to show the names of all employees concatenated with their jobtypes.

Answer =

SELECT CONCAT (ename, job) FROM Empl;