Saturday, June 6, 2020

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)


3. Retrieve the birthdate and address of the employee whose name is 'Franklin T. Wong'(COMPANY DATABASE NAVATHE BOOK)

3. Retrieve the birthdate and address of the employee whose name is 'Franklin T. Wong'(COMPANY DATABASE NAVATHE BOOK)


2. Display ssn, lname, fname, address of employees who work in department no 7. (COMPANY DATABASE NAVATHE BOOK)

2. Display ssn, lname, fname, address of employees who work in department no 7. (COMPANY DATABASE NAVATHE BOOK)