Which of the following SQL statements will display the names of all customers who have purchased a copy of E-BUSINESS THE EASY WAY?
a. SELECT lastname, firstnameFROM customers NATURAL JOIN booksWHERE title LIKE '%BUSI%';
b. SELECT lastname, firstnameFROM customers c, books b, orders o, orderitems oiWHERE title LIKE '%BUSI%';
c. SELECT lastname, firstnameFROM customers c, books b, orders o, orderitems oiWHERE c.customer# = o.customer# AND o.order# = oi.order# ANDoi.isbn = b.isbn AND title LIKE '%BUSI%';
d. none of the above
c
You might also like to view...
If 63% of consumers are aware of JM Manufacturers Inc's 3-D television, 38% of that group likes the product's benefit, 54% of that group finds the price acceptable, 21% of that group intend to buy the product, and 48% of that group actually purchase
the product from JM Manufacturers, then the share potential index for the 3-D television is ________. A) 1.3% B) 2.7% C) 3.4% D) 6.2% E) 10.1%
Which of the following is true regarding the pragmatic nationalist view of FDI?
A. One aspect of pragmatic nationalism is the tendency to aggressively court FDI believed to be in the national interest by, for example, offering subsidies to foreign MNEs in the form of tax breaks or grants. B. The pragmatic nationalist view states that FDI always has a positive effect on the balance of payments which arises from the outflow of a foreign subsidiary's earnings and from the import of inputs from abroad. C. According to the pragmatic nationalist view, international production should be distributed among countries based on the theory of comparative advantage. D. According to the pragmatic nationalist view, FDI should not be allowed to enter into a country because its costs always outweigh its benefits. E. The pragmatic nationalist view of FDI accepts the Marxist theory, and suggests that FDI by MNEs is an instrument of imperialism.