SELECT
    customer_recent_spend_categories.name, COUNT(*)
FROM
    customers
        LEFT JOIN
    customer_recent_spend_categories ON customer_recent_spend_categories.id = (SELECT
            id
        FROM
            customer_recent_spend_categories
        WHERE
            value < (SELECT
                    SUM(sell_total) / 1.2
                FROM
                    orders
                WHERE
                    customers.id = customer_id
                        AND inserted = 1
                        AND orders.created_at >= (NOW() - INTERVAL 90 DAY)
                        AND orders.deleted_at IS NULL
                GROUP BY customer_id)
                AND customer_recent_spend_categories.deleted_at IS NULL
        ORDER BY value DESC
        LIMIT 1)
WHERE
    customer_recent_spend_categories.name IN ('A' , 'B', 'C', 'D', 'E', 'F', 'G')
GROUP BY customer_recent_spend_categories.name