part2:

Write a SELECT statement that returns six columns based on the empFirstName, empLastName and EmpDateOfBirth fields in the EMPLOYEE table:

1 The employee first and last names concatenated with a space between the name parts

2 Use the CAST function to return the first column as a data type varchar

3 Use EmpDateOfBirth and the CONVERT function to return the second, third and fourth columns as a varchar, using style 1, 7 and 10 respectively.

4 Use the EmpDateOfBirth and the CAST function to return the fifth column as data type real

5 Display the unformatted empDateOfBirth as the sixth column

6 Use appropriate descriptive column alias names