Given the following database where primary key attributes are underlined:
employee(employee_name, city, street)
works(employee_name, company_name, salary)
company(company_name, city, street)
We want to find the employee_name, city of residence, and salary for all employees who work for the company Fedco. Which of the following queries is NOT a correct way for doing that?
O SELECT employee_name, city, salary FROM employee natural join works WHERE company_name = 'Fedco';
O SELECT employee.employee_name, city, salary FROM employee, works WHERE employee.employee_name = works.employee_name and company_name = 'Fedco';
O SELECT employee.employee_name, city, salary FROM employee, works WHERE (employee.employee_name, company_name) = (works.employee_name, 'Fedco');
O None of these
