WITH tbl_base AS (

    -- Base level sub-query on a table containing about 22000 rows, using LEFT JOIN on 5 other tables, details not relevant here

    SELECT ……… FROM <many things>

), tbl_middle AS (

    -- Intermediate level sub-query #1 for intermediate computing, details not relevant here

    SELECT ……… FROM tbl_middle …

), tbl_states AS (

    -- Intermediate level sub-query #2 for intermediate computing, details not relevant here

    SELECT

        ……… AS state,

        ……… AS `elec`

    FROM    tbl_states …

), tbl_sums AS (

    -- Final grouping query

    SELECT

        `state`,

        SUM(NOT `elec`) AS `vls`,

        SUM(`elec`) AS `vae`,

        count(`state`) AS `all`

    FROM tbl_states

    GROUP BY `state`

    ORDER BY `state`

)

-- Additional query which could be avoided if left as simple as this but it will not stay as simple as this

SELECT `state`, `vae`, `vls`, `both` FROM tbl_sums

SELECT `state`, `vae`, `vls`, `both` FROM tbl_sums

UNION

SELECT 'all_sta',SUM(`vls`),SUM(`vae`),SUM(`both`) FROM tbl_sums WHERE `state` IN ('ok','warn','bad','maint')

UNION

SELECT 'all_run',SUM(`vls`),SUM(`vae`),SUM(`both`) FROM tbl_sums WHERE `state` IN ('run','longrun')

UNION

SELECT 'operative',SUM(`vls`),SUM(`vae`),SUM(`both`) FROM tbl_sums WHERE `state` IN ('ok','warn','run','longrun')

UNION

SELECT 'unusable',SUM(`vls`),SUM(`vae`),SUM(`both`) FROM tbl_sums WHERE `state` IN ('bad','maint')

UNION

SELECT 'present',SUM(`vls`),SUM(`vae`),SUM(`both`) FROM tbl_sums WHERE `state` IN ('ok','warn','bad','maint','run','longrun')

UNION

SELECT 'missing',SUM(`vls`),SUM(`vae`),SUM(`both`) FROM tbl_sums WHERE `state` IN ('removed','lost')

UNION

SELECT 'total',SUM(`vls`),SUM(`vae`),SUM(`both`) FROM tbl_sums