Average items per order from compressed data

Average items per order from compressed data

Alibaba stores its order distribution in a compressed table: for each number of items in an order, the table shows how many orders had that item count. Calculate the average number of items per order, round the result to one decimal place, and return it in the mean column.

Any row order

Alibaba

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid