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
Get step-by-step solutions from verified subject matter experts
