Choose the letter of the SQL statement that should return the most records. Assume the database has been used for many years.

 

Choose the letter of the SQL statement that should return the most records. Assume the database has been used for many years. SELECT e.first_name, e.last_name, a.salary FROM employee e, assignment a WHERE e.employee_id = a.employee_id; SELECT e.first_name, e.last_name, a.salary FROM employee e, assignment a WHERE e.employee_id = a.employee_id AND e.status = 'A'; SELECT e.first_name, e.last_name, SUM(a.salary) FROM employee e, assignment a WHERE e.employee_id = a.employee_id GROUP BY e.first_name, e.last_name; SELECT first_name, last_name FROM employee WHERE status = 'A';