21. Find the sum of the salaries of all employees, the maximum salary, the minimum salary, and the average salary. Display with proper headings.(COMPANY DATABASE NAVATHE BOOK)
Saturday, June 6, 2020
20. Retrieve the employee numbers of all employees who work on project located in Bellaire, Houston, or Stafford.(COMPANY DATABASE NAVATHE BOOK)
20. Retrieve the employee numbers of all employees who work on project located in Bellaire, Houston, or Stafford.(COMPANY DATABASE NAVATHE BOOK)
19. Retrieve the name of each employee who has a dependent with the same first name and same sex as the employee.(COMPANY DATABASE NAVATHE BOOK)
19. Retrieve the name of each employee who has a dependent with the same first name and same sex as the employee.(COMPANY DATABASE NAVATHE BOOK)
18. Select the names of employees whose salary does not match with salary of any employee in department 10.(COMPANY DATABASE NAVATHE BOOK)
18. Select the names of employees whose salary does not match with salary of any employee in department 10.(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)
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)
Subscribe to:
Posts (Atom)