Average salary of an employee in particular department of company is greater than the average salary of employees in the company

Employee(SSN,name,salary,dep_no,MGRSSN)
customer(acoount_no,name,lenderSSN)
loan(loan_number,amount,account_number)
Foreign Keys:
MGRSSN references Employee.SSN (Manager SSN)
Customer.LenderSSN references Employee.SSN
Loan.AccountNo references Customer.AccountNo

 

This Question is not yet answered!

 

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions