Structure of the PROMOTION Table

Multiple Choice

Structure of the PROMOTION table

Structure of the BOOKS table

Structure of the ORDERITEMS table
-Which of the following SQL statements will display the gift or gifts that should be sent with order# 1003?

A) SELECT gift
FROM promotion
WHERE order# = 1003;
B) SELECT gift
FROM promotion NATURAL JOIN books
WHERE order# = 1003;
C) isbn AND order# = 1003;
D) SELECT gift
FROM promotion, orderitems oi, books b
WHERE retail BETWEEN minretail AND maxretail
AND oi.isbn =
E) none of the above