Untitled

SELECT 
    COUNT(serialnumber) serials,
    bin,
    location,
    previouslocation,
    lastscandate
FROM
    inventoryitem
WHERE
    (location LIKE '7-L%'
        OR location LIKE '7-UL%')
        AND previouslocation = 'repack'
        AND qtyonhand = 1
GROUP BY bin
ORDER BY location ASC