The Following Queries Produce the Same Results

question 65

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:

Soybean Oil

A vegetable oil extracted from the seeds of the soybean, used in cooking and in the production of various food products and industrial applications.

Unsaturated Fatty Acid

A fatty acid that contains one or more double bonds between carbon atoms, which can influence the fluidity of cell membranes and are often found in plant oils.

Saturated Fatty Acid

A type of fatty acid where all carbon atoms are bonded to hydrogen atoms, without any double bonds.

Lecithin

A fatty substance found in plant and animal tissues, used as an emulsifier in food products, as well as in pharmaceutical and cosmetic formulations.