Saturday, June 6, 2020

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)


8. Retrieve all employees in department 5 whose salary is between 50,000 and 60,000(inclusive)(COMPANY DATABASE NAVATHE BOOK)

8. Retrieve all employees in department 5 whose salary is between 50,000 and 60,000(inclusive)(COMPANY DATABASE NAVATHE BOOK)


7. Retrieve all employees who were born during the 1950s.(COMPANY DATABASE NAVATHE BOOK)

7. Retrieve all employees who were born during the 1950s.(COMPANY DATABASE NAVATHE BOOK)


6. Retrieve all employee names whose address is in „Bellaire‟(COMPANY DATABASE NAVATHE BOOK)

6. Retrieve all employee names whose address is in „Bellaire‟(COMPANY DATABASE NAVATHE BOOK)

5. Retrieve all distinct salary values. (COMPANY DATABASE NAVATHE BOOK)

5. Retrieve all distinct salary values. (COMPANY DATABASE NAVATHE BOOK)


4. Retrieve the name and salary of every employee.(COMPANY DATABASE NAVATHE BOOK)

4. Retrieve the name and salary of every employee.(COMPANY DATABASE NAVATHE BOOK)