Question: 2 . Consider an employee database with two relations employee ( employee - name , street , city ) works ( employee - name ,

2 . Consider an employee database with two relations employee ( employee - name , street , city ) works ( employee - name , company - name , Salary ) where the primary keys are underlined . Write a query to find companies whose employees early a lower salary , on average , than the average salary at " First Bank Corporation " . ['se user defined SQL functions ( create function command ) as appropriate to answer the above query , the function takes the company name as the input and returns the average salary of the given company . ( 6 points )
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
