Answer to Question #265431 in Engineering for Rahul

Question

Write SQL Queries for following set of tables:

EMPLOYEE (EmpNo, Name, DoB, Address, Gender, Salary, DNumber) ,

DEPARTMENT (DNumber, Dname, ManagerEmpNo, MnagerStartDate).

Write the following queries ( create table and add random data):

i) Display the Age of ‘male’ employees.

ii) Display all employees in Department named ‘Marketing’.

iii) Display the name of highest salary paid ‘female’ employee.

iv) Which employee is oldest manger in company?

v) Display the name of department of the employee ‘SMITH’

Answer 1

Dear Rahul, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order