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 (

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!