18. Select the names of employees whose salary does not match with salary of any employee in department 10.(COMPANY DATABASE NAVATHE BOOK)
Saturday, June 6, 2020
17. Retrieve a list of employees and the project name each works in, ordered by the employee's department, and within each department ordered alphabetically by employee first name. (COMPANY DATABASE NAVATHE BOOK)
17. Retrieve a list of employees and the project name each works in, ordered by the employee's department, and within each department ordered alphabetically by employee first name. (COMPANY DATABASE NAVATHE BOOK)
16. Increase the salary of all employees working on the 'ProductX' project by 15%. Retrieve employee name and increased salary of these employees.(COMPANY DATABASE NAVATHE BOOK)
16. Increase the salary of all employees working on the 'ProductX' project by 15%. Retrieve employee name and increased salary of these employees.(COMPANY DATABASE NAVATHE BOOK)
15. Make a list of all project numbers for projects that involve an employee whose last name is 'Narayan‟ either as a worker or as a manager of the department that controls the project.(COMPANY DATABASE NAVATHE BOOK)
15. Make a list of all project numbers for projects that involve an employee whose last name is 'Narayan‟ either as a worker or as a manager of the department that controls the project.(COMPANY DATABASE NAVATHE BOOK)
14. Retrieve all combinations of Employee Name and Department Name. (COMPANY DATABASE NAVATHE BOOK)
14. Retrieve all combinations of Employee Name and Department Name. (COMPANY DATABASE NAVATHE BOOK)
13. For each employee, retrieve the employee's name, and the name of his or her immediate supervisor.(COMPANY DATABASE NAVATHE BOOK)
13. For each employee, retrieve the employee's name, and the name of his or her immediate supervisor.(COMPANY DATABASE NAVATHE BOOK)
12. For every project located in 'Stafford', list the project number, the controlling department number, and the department manager's last name, address, and birthdate.(COMPANY DATABASE NAVATHE BOOK)
12. For every project located in 'Stafford', list the project number, the controlling department number, and the department manager's last name, address, and birthdate.(COMPANY DATABASE NAVATHE BOOK)
11. Retrieve the name and address of all employees who work for the 'Research' department(COMPANY DATABASE NAVATHE BOOK)
11. Retrieve the name and address of all employees who work for the 'Research' department(COMPANY DATABASE NAVATHE BOOK)
10. Retrieve SSN and department name for all employees.(COMPANY DATABASE NAVATHE BOOK)
10. Retrieve SSN and department name for all employees.(COMPANY DATABASE NAVATHE BOOK)
9. Retrieve the names of all employees who do not have supervisors(COMPANY DATABASE NAVATHE BOOK)
9. Retrieve the names of all employees who do not have supervisors(COMPANY DATABASE NAVATHE BOOK)
Subscribe to:
Posts (Atom)