The Following Queries Produce the Same Results

question 74

True/False

The following queries produce the same results.
Select DISTINCT customer_name, customer_city
from customer, salesman
where customer.salesman_id = salesman.salesman_id
and salesman.lname = 'SMITH';
select customer_name, customer_city
from customer
where customer.salesman_id =
(select salesman_id
from salesman
where lname = 'SMITH');

---

Definitions:

Units of Output

The quantity of product that a company produces in a given period.

Marginal Costs

The increase in total production cost that arises from producing one additional unit of a good or service.

Average Fixed Cost Curve

A graph that shows the fixed costs of production divided by the quantity of output produced, illustrating how these costs dilute over larger production volumes.

U-Shaped

A descriptive term often used in economics and statistics to describe a graph or curve that resembles the shape of the letter "U", indicating a particular kind of relationship or trend.