Question: Consider this relational database schema where the primary keys are in itallics , and the foreign keys are in bold . employee ( person-name ,
Consider this relational database schema where the primary keys are in itallics, and the foreign keys are in bold.
| employee (person-name, street, city) works (person-name, company-name, salary) company (company-name, city) manages (person-name, manager-name) |
Create a query that will find all companies whose employees earn a higher salary, on average, than the average salary at 'Walmart'.
*** A good explaination will get upvoted ***
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
