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:

Intervening Cause

An event that occurs after the defendant's act that contributes to the harm or damage, potentially absolving the defendant of liability because it breaks the chain of causation.

Reasonably Necessary

A standard requiring actions or measures that are logically appropriate and needed to achieve a certain goal or outcome, considering the circumstances.

Risk Of Harm

The potential for individuals to experience injury, damage, or loss as a result of certain actions or events.

Negligence Per Se

The doctrine that provides that a conclusive presumption of breach of duty arises when a defendant has violated a statute and thereby caused a harm the statute was designed to prevent to a person the statute was designed to protect.