23. Select the names of employees whose salary is greater than the average salary of all employees in department 10.(COMPANY DATABASE NAVATHE BOOK)
Saturday, June 6, 2020
22. Find the sum of the salaries and number of employees of all employees of the „Marketing‟ department, as well as the maximum salary, the minimum salary, and the average salary in this department.(COMPANY DATABASE NAVATHE BOOK)
22. Find the sum of the salaries and number of employees of all employees of the „Marketing‟ department, as well as the maximum salary, the minimum salary, and the average salary in this department.(COMPANY DATABASE NAVATHE BOOK)
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)
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)
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)
Subscribe to:
Posts (Atom)