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

Answer:

The SQL query to be used to get the desired output is:

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

FROM employees e, sales s

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

In database a query is a question generally expressed in a formal way. A database query can be a select query or an action query. A select query retrieves data from the database whereas an action query performs certain actions on the database such as inserting, updating and deleting the data.

Answer 2

Answer:

$\huge \red{❥ }{ƛ} \pink{ղ} \blue{Տ} \purple{ա} \orange{ҽ} \color{blue}{ɾ } \green{ \: ࿐} \color{purple}$

$\:$

The SQL query to be used to get the desired output is:

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

FROM employees e, sales s

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

In database a query is a question generally expressed in a formal way. A database query can be a select query or an action query. A select query retrieves data from the database whereas an action query performs certain actions on the database such as inserting, updating and deleting the data.

$\:$

$\color{red}{ ❥@ʂῳɛɛɬƈąŋɖყ}$