Question

You have two tables named employees and sales. You want to identify the sales representatives who have generated at least $100,000 in revenue. Which query should you issue?

Answer 1

You have two tables named EMPLOYEES and SALES. You ... who have generated at least $100,000 in revenue.

Answer 2

Answer:

The query issued will be following:

SELECT first_name, last_name, sales

FROM employees e, sales s

WHERE e.employee_id = s.employee_id AND revenue > 100000;

SELECT e.first_name, e.last_name, s.sales

FROM employees e, sales s

WHERE e.employee_id = s.employee_id AND revenue > 100000;

SELECT e.first_name, e.last_name, s.sales

FROM employees e, sales s

WHERE e.employee_id = s.employee_id AND revenue >= 100000;

(*)

SELECT e.first_name, e.last_name, s.sales

FROM employees, sales

WHERE e.employee_id = s.employee_id AND revenue >= 100000;