Question: Answer the below with an RA query using the following databases below employee (person_name, street, city) works (person_name, company_name, salary) company (company_name, city) E) Find

Answer the below with an RA query using the following databases below

employee (person_name, street, city)

works (person_name, company_name, salary)

company (company_name, city)

E) Find the company with the most employees. [Note: The query should return the name of the company which has the largest number of employees

F) Find the company with the smallest payroll. [Note: Payroll is the sum of salaries for all employees. The query should return the name of the company which has the smallest payroll

G) Find those companies whose employees earn a higher salary, on average, than the average salary at First Bank Corporation

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 Databases Questions!