Based upon the contents of the ORDERS table in the accompanying figure, which of the following SQL statements will list all orders placed by customer # 1020 that have not yet been shipped?
a. SELECT FROM orders WHERE customer# = 1020 OR shipdate = NULL;
b. SELECT FROM orders WHERE customer# = 1020 AND shipdate IS NULL;
c. SELECT FROM orders WHERE customer# = 1020 OR shipdate IS NULL;
d. SELECT FROM orders WHERE customer# = 1020 AND shipdate = NULL;
.D
You might also like to view...
Reverse logistics refers to the moving of products and materials from suppliers to the factory
Indicate whether the statement is true or false
A banker may perform a financial ratio analysis to assess a firm's ability to repay debt in a timely manner.
Answer the following statement true (T) or false (F)
Which of the following is the most likely reason for most unions to insist on group-based performance measures with equal payouts to members?
A. It enables employees to learn new skills. B. It causes a leniency effect. C. It cuts down on strife and internal quarrels. D. It encourages individual differences.
If you rent an apartment, the apartment is known as:
a. a renthold b. a retainer c. a lease in absentia d. a defeasement e. none of the other choices are correct