View the Exhibit; e xamine the structure of the PROMOTIONS table. Each promotion has a
duration of at least seven days. Your manager has asked you to generate a report, which
provides the weekly cost for each promotion done to l date. Which query would achieve the
required result?
A.
SELECT promo_name, promo_cost/((promo_end_date-promo_begin_date)/7) FROM
promotions;
B.
SELECT promo_name, promo_cost/(promo_end_date-promo_begin_date/7) FROM
promotions;
C.
SELECT promo_name,(promo_cost/promo_end_date-promo_begin_date)/7 FROM
promotions;
D.
SELECT promo_name, promo_cost/promo_end_date-promo_begin_date/7 FROM
promotions;