OCP-1Z0-051 第10题

一、原题

View the Exhibit; examine 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

答案：D

二、题目翻译

查看PROMOTIONS表结构。
每个促销活动的促销期至少持续七天。
你的经理让你去生成一个报表，该报表提供促销期间每周的成本。
哪个查询能得到所需的结果？