Question

Which SQL statement retrieves gift items from the promotion table for order #1003, where the retail price of books falls within a specified range?

A. SELECT gift FROM promotion, orderitems oi, books b WHERE retail BETWEEN minretail AND maxretail AND = AND order# = 1003;
B. SELECT title, cost, contact, phone FROM publisher JOIN books USING (pubid);
C. within the rectangular survey system area in which the land being surveyed is located.
D. must commence and finish at the same identifiable point.
E. refer to a registered subdivision plat map.

Answer 1

The best SQL statement would join the promotion, order items, and books tables, and include conditions on the retail price and order number. None of the provided options are completely correct as they contain errors or are incomplete.

Step-by-step explanation:

To retrieve gift items from the promotion table for order #1003, where the retail price of books falls within a specified range, the correct SQL statement would need to incorporate a JOIN between the promotion, orderitems (alias oi), and books (alias b) tables, and specify the conditions matching the retail price range as well as the order number. The correct format for such a statement would likely be as follows:

SELECT gift FROM promotion
JOIN orderitems oi ON promotion.orderitemid = oi.id
JOIN books b ON oi.bookid = b.id
WHERE b.retail BETWEEN minretail AND maxretail
AND oi.order# = 1003;

However, as the provided options contain mistakes or are incomplete, none of them directly answers the question as it's described.