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:

Peripheral

Relating to or situated on the edge or periphery of something; not central.

Cerebral Hemispheric Specialization

The notion that different functions or cognitive processes are more dominant in one hemisphere of the brain than the other.

Curricular Reform

The process of making changes and updates to educational course content and structure to improve learning outcomes.

High School

An educational institution that provides secondary education, typically to students aged between 14 and 18 years old.