Title: Which of the following SQL statements will display the names of all customers who have purchased a ... Post by: Micky5490! on Jan 31, 2018 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 Title: Which of the following SQL statements will display the names of all customers who have purchased a ... Post by: cedd123 on Jan 31, 2018 Content hidden
|