Question

5. Show the employees full name, their full address, email, job title, hire date and salary. You must format the full name of the employee and full address. You must also format their salary to show as $20,000.00 and Format the date the hire date must show as March 24, 2019 The job title must be in alphabetical order.

USING MYSQL

Answer 1

If you have any doubts, please give me comment...

SELECT CONCAT(FirstName, " ", LastName) AS FullName, CONCAT(Address, ", ", City, ", ", State,", ", ZipCode) AS FullAddress, Email, JobTitle, DATE_FORMAT(HireDate, "%M %d, %Y") AS HireDate, CONCAT('$',FORMAT(Salary, 2)) AS Salary

FROM Employees

ORDER BY JobTitle;