Untitled

SELECT 
    COUNT(i.serialnumber) qty,
    i.size,
    i.product,
    p.name,
    p.wholesalecost AS priceperunit,
    FORMAT(SUM(p.wholesalecost), 'c') RoundedCost
FROM
    (SELECT 
        serialnumber, product, size
    FROM
        inventoryitem
    WHERE
        (location LIKE 'APOPStore-RackMoore%'
            OR location LIKE 'APOPStore-FRONTPalletMoore%'
            OR location LIKE 'APOPStore-BACKPalletMoor%')
            AND qtyonhand = 1) i
        JOIN
    product p ON p.code = i.product
GROUP BY i.product