Write a query to get the department name for all employees. Include the employee's first name,...

Transcribed Image Text:

Write a query to get the department name for all employees. Include the employee's first name, last name, and department name in your output (In that order). Sort the list by department name in ascending order, then by employee last name in ascending order and employee first name in ascending order (this query uses multiple tables). Write a query to get all unique first names that start with the letter P from the employees table. Output the names in all upper case. Sort the results in ascending order. Write a query to get the first 3 characters of all last names that start with an H from the employees table and sort them in descending order. Write a query to get the department name for all employees. Include the employee's first name, last name, and department name in your output (In that order). Sort the list by department name in ascending order, then by employee last name in ascending order and employee first name in ascending order (this query uses multiple tables). Write a query to get all unique first names that start with the letter P from the employees table. Output the names in all upper case. Sort the results in ascending order. Write a query to get the first 3 characters of all last names that start with an H from the employees table and sort them in descending order.