Untitled

SELECT 
    count(serialnumber) serials, product, size, bin, location, previouslocation, lastscandate
FROM
    inventoryitem
WHERE
    product IN ('ANIN-WS125' , 'ANIN-WK134', 'LCDE-WD373', 'ANIN-WS109')and location like '7-%'
        AND qtyonhand = 1
        group by bin
        order by location asc