Calculate Weighted Average In Sql For Duplicate Items

TABLE ITEM | SKU | QUANT | ITEM LANDING -----+-------+---------+----------------- ABC | A-B-C | 5 | 500 ABC | A-B-C | 10 | 400 DEF | D-E

Solution 1:

SELECT ITEMNAME, ITEMSKU, SUM(QUANT), SUM(QUANT * ITEM_LANDING) / SUM(QUANT)
FROM <YourTable>
GROUP BY ITEMNAME, ITEMSKU

Solution 2:

Try this...

QUERY

SELECT item_name AS 'ITEM NAME',
item_sku AS ' ITEM SKU', 
SUM(quant) AS 'QUANT',
(SUM(quant*item_landing)/sum(quant)) AS 'ITEM LANDING'
FROM items
GROUP BY item_name;

SQL FIDDLE