Untitled

SELECT 
    COUNT(DISTINCT serialnumber) serial,
    product,
    size,
    location,
    PONum
FROM
    inventoryitem
WHERE
    product = 'VSDE-WU27'
        AND location = 'QC Pending'
        AND qtyonhand = 1
GROUP BY PONum