Which of the following SQL statements will return the names of all customers who placed an order on April 12, 2003?
a. SELECT lastname, firstnameFROM customersWHERE orderdate = '12-APR-03';
b. SELECT lastname, firstnameFROM customers NATURAL JOIN ordersWHERE orderdate = '12-APR-03';
c. SELECT lastname, firstnameFROM customers JOIN orders ON (customer#)WHERE orderdate = '12-APR-03';
d. both a and b
b
Business
You might also like to view...
Dana works ________ than Susan
A) more efficiently B) most efficiently C) more efficient
Business
A process control chart used to monitor the sample means of variables that result from a process and is often used in quality control best defines
A) X-bar charts. B) R-charts. C) P-charts. D) C-charts.
Business