In calendar year $2006,$ the CMO of Adventure Works executed a series of

$--$promotions extending larger than normal discount amounts to resellers'

$--$purchases of products across our Bikes category to drive larger orders

$--$through this channel. These promotions were scaled back in $2007$ and

$--$replaced with a series of smaller promotional offers still targeting

$--$the sale of Bikes but applicable across a wider range of order sizes.

$--$Some of our larger resellers complained about this shift in promotional

$--$practices, stating that their average discount amount on Bikes is smaller

$--$in $2007$ than in $2006.$ However, our CMO contends that the average discount

$--$amount applied to Bicycle purchases across the reseller channel has

$--$remained about the same between $2006$ and $2007.$ How could both parties have

$--$such differing views of the situation?

$--$Provide me a SQL query evaluating discount amounts applied to 'Bikes' in

$--$calendar years $2006$ & $2007.$ Include averages of discount amount $($with no

$--$ consideration of order quantities$)$ that reflect both the CMO and the

$--$ reseller's point of views.