Problem $54$

One of the purchasing managers is interested in the impact of product prices on the sale of products of each brand. Write a query to display the brand name, brand type, average price of products of each brand, and total units sold of products of each brand. Even if a product has been sold more than once, its price should only be included once in the calculation of the average price. However, you must be careful because multiple products of the same brand can have the same price, and each of those products must be included in the calculation of the brand$$s average price. Sort the result by brand name $($Figure P$7\mathrm{.}54).$

Result for average price and total units sold of products by brand are displayed in $4$ columns, brand underscore name, brand underscore type, average price and units sold. There are $9$ rows in the table; the values are as follows. Row $1$: brand underscore name, Binder Prime; brand underscore type, Premium; average price, $16\mathrm{.}12$; units sold, $3753.$ Row $2$: brand underscore name, Busters; brand underscore type, Value; average price, $22\mathrm{.}59$; units sold, $3727.$ Row $3$: brand underscore name, Foresters Best; brand underscore type, Value; average price, $20\mathrm{.}94$; units sold, $2086.$ Row $4$: brand underscore name, Home Comfort; brand underscore type, Contractor; average price, $21\mathrm{.}8$; units sold, $4842.$ Row $5$: brand underscore name, Le Mode; brand underscore type, Premium; average price, $19\mathrm{.}22$; units sold, $5284.$ Row $6$: brand underscore name, Long Haul; brand underscore type, contractor; average price, $20\mathrm{.}12$; units sold, $5728.$ Row $7$: brand underscore name, Olde Tyme Quality; brand underscore type, contractor; average price, $18\mathrm{.}33$; units sold, $3614.$ Row $8$: brand underscore name, Stuttenfurst; brand underscore type, Contractor; average price, $16\mathrm{.}47$; units sold, $3671.$ Row $9$: brand underscore name, Valumatte; brand underscore type, Value; average price, $16\mathrm{.}84$; units sold, $2485.$

Figure P$7\mathrm{.}54$

Task $54$: Complete Problem $54$ above.