How and why if you could please . you can use your own . 1.Write a query to disp

Question

How and why if you could please .

you can use your own .

1.Write a query to display employee number, employee name, hiredate, manager's name for those employees, whose manager's name starts with K or M or S. Label the columns Employee Number, Employee Name, Hiredate, Mgr Name.

2. Create a query that will display the employee name, department number, department name and all the employees that work in the same department as a given employee. Give each column an appropriate label.

3. Write a query to display the department name, location of all employees who are clerks.

Explanation / Answer

select employee number, employee name, hiredate, managers name from employees where managers name like 'K%' OR managers name like 'M%' or managers name like 'S%'

select employee name, department number, department name where department name = (select department name from emlpyees where name='abc')

select departmentname, location from employees where designation = clerk

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.