Question: 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

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.
Step by Step Solution
There are 3 Steps involved in it
1 SELECT efirstname elastname ddepartmentname FROM employees e JOIN department... View full answer
Get step-by-step solutions from verified subject matter experts
