#1064

Average Line Quantity

Logistics wants the average item quantity per line for each order: divide total qty for the order by its number of lines and round to 2 decimal places. Return order_id and avg_qty, sorted by order_id.

Sampla aschuir a bhfuiltear ag súil leis

Seo é an chuma a bheadh ar fhreagra ceart — tá a líon rónna féin aige, ní gá dó na táblaí scéime a mheaitseáil.

avg_qtyorder_id
3.510
111
1.512

Beidh toradh d'iarratais le feiceáil anseo