Untitled

SELECT 
    serialnumber, product, size, bin, location
FROM
    inventoryitem
WHERE
    product LIKE 'NKAM%' AND qtyonhand = 1
        AND orderhistory = ''
        AND location LIKE '7-%'
        group by product
        order by location asc