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!

 
 

Related Answered Questions

 

Related Open Questions