Studio audit

SELECT 
    COUNT(serialnumber) serials,
    CONCAT('$', FORMAT(SUM(cost), 'c')) sumcost,
    location
FROM
    inventoryitem
WHERE
    location IN ('Editorial' , 'Editorial - Off Site',
        'Copywriting',
        'Editorial Styling',
        'Editorial - Stills',
        'Model Size',
        'Model Size - Steaming',
        'Photo Studio',
        'Sellable Photo Studio',
        'Studio Building',
        'Studio Expense',
        'Styling',
        'Social',
        'Pulls')
        AND qtyonhand = 1
        AND DATE(lastscandate) <= '2024-06-31'
GROUP BY location
ORDER BY location , lastscandate ASC;

SELECT 
    cost,
    CONCAT('s', serialnumber) serial,
    product,
    size,
    bin,
    location,
    SUBSTRING_INDEX(SUBSTRING_INDEX(locationhistory, ']', 1),
            ',',
            - 1) lasttouch,
    lastscandate
FROM
    inventoryitem
WHERE
    location IN ('Editorial' , 'Editorial - Off Site',
        'Copywriting',
        'Editorial Styling',
        'Editorial - Stills',
        'Model Size',
        'Model Size - Steaming',
        'Photo Studio',
        'Sellable Photo Studio',
        'Studio Building',
        'Studio Expense',
        'Styling',
        'Social',
        'Pulls',
        'Copywriting')
        AND qtyonhand = 1
        AND DATE(lastscandate) <= '2024-06-31'
ORDER BY location , lastscandate ASC