SELECT l.location_id, l.city, d.department_nameĦ. SELECT l.location_id, l.city, d.department_name Finish this code to produce all information in the departments table whether it has a match in the locations table or not: SELECT e.last_name, e.department_id, d.department_nameĥ. SELECT e.last_name, e.department_id, d.department_name Finish this code to produce all possible combinations of rows from both tables: Where e.manager_id=m.employee_id and e.hire_dateĤ. select e.first_name' 'e.last_name "Employee",e.hire_date "Emp Hire",m.first_name' 'm.last_name "Manager",m.hire_date "Mgr Hire" Label the columns Employee, Emp Hired, Manager, and Mgr Hired, respectively Display the names and hire dates for all employees who were hired before their managers, along with their managers' names and hire dates. Order the list alphabetically by the last name of the employee.ģ. Modify question 1 to display all employees and their managers, even if the employee does not have a manager. select e.last_name "Employee",e.employee_id "Emp #",m.manager_id "Mgr #",m.last_name "Manager"Ģ. Label the columns:Employee, Emp#, Manager, and Mgr#, respectively. Display the employee's last name and employee number along with the manager's last name and manager number.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |