OCP-1Z0-051-Question Analysis-10th question

10. View the Exhibit and 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 wocould 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;

Answer: D

Question Analysis:

It means the average consumption per week during the promotion period.

According to the table given: the total cost of promotion is promo_cost length of promotion (promo_end_date-promo_begin_date), the length of promotion to the week need to divide 7

(Promo_end_date-promo_begin_date)/7, so the average weekly spending is promo_cost/(promo_end_date-promo_begin_date)/7)

Obviously, expression D is correct. This mainly deals with the order of expression operations. The answer ABC will prompt a syntax error during execution.