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?
a) SELECT e.first_name, e.last_name, s.sales
FROM employees, sales
WHERE e.employee_id = s.employee_id AND revenue >= 100000;
b)SELECT first_name, last_name, sales
FROM employees e, sales s
WHERE e.employee_id = s.employee_id AND revenue > 100000;
c) SELECT e.first_name, e.last_name, s.sales
FROM employees e, sales s
WHERE e.employee_id = s.employee_id AND revenue > 100000;
d) SELECT e.first_name, e.last_name, s.sales
FROM employees e, sales s
WHERE e.employee_id = s.employee_id AND revenue >= 100000;

Answer 1

To identify sales representatives who have met a revenue threshold, the correct SQL query is 'SELECT e.first_name, e.last_name, s.sales FROM employees e, sales s WHERE e.employee_id = s.employee_id AND s.revenue >= 100000;'. This query joins the two tables on employee_id and filters for revenues of at least $100,000.

Step-by-step explanation:

The correct query to identify the sales representatives who have generated at least $100,000 in revenue is:

c) SELECT e.first_name, e.last_name, s.sales
FROM employees e, sales s
WHERE e.employee_id = s.employee_id AND s.revenue >= 100000;

In this query, we are selecting first name and last name from the employees table and sales from the sales table. The WHERE clause is used to specify that we want to include only those records where the employee_id from the employees table matches the employee_id from the sales table, and the revenue is greater than or equal to 100000.