Answer to Question #265431 in Engineering for Rahul

Question #265431

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’

1
Expert's answer
2021-11-24T13:02:04-0500
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

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be the first!

Leave a comment

LATEST TUTORIALS
New on Blog
APPROVED BY CLIENTS