Untitled

SELECT 
    COUNT(serialnumber) serials,
    location,
    DATE(lastscandate) date
FROM
    inventoryitem
WHERE
    location = 'PA Replenishment in-transit'
        AND qtyonhand = 1
GROUP BY date