#IT-6202
Awesome StudentQuestion • Database Management System 1 (Oracle)

Choose the letter of the correct answer based on the table EMPLOYEES as shown below.Table 1.0 EMPLOYEESWhat query should be used in order to display the employees lastname concatenated with firstname and with a =E2=80=98, (comma)' in between. A rename on the concatenated column as Complete Name. Note all values in Complete Name column should be in lowercase plus display the length of employees lastname for all employees whose lastname starts with letter M sort the lastname in its default order.

Answer

SELECT LOWER(LASTNAME||','||FIRSTNAME) AS "COMPLETE NAME",LENGTH(LASTNAME)FROM EMPLOYEESWHERE LASTNAME LIKE 'M%';