Untitled

SELECT 
    count(serialnumber) serial,
    bin,
    location,
    previousbin,
    previouslocation
FROM
    inventoryitem
WHERE
    location = 'qc pending' and bin = 'bDamagedInventory'
        AND qtyonhand = 1
        group by previousbin
ORDER BY previouslocation ASC