Query editor
WITHTotal AS (SELECTCOUNT(*) as total_numFROMdune.substrate.result_polkadot_proposals_proposed),Voting AS (SELECTCOUNT(*) as voting_numFROMdune.substrate.result_polkadot_proposals_proposedWHEREstatus = 'Decision Started'),Confirming AS (SELECTCOUNT(*) as confirming_numFROMdune.substrate.result_polkadot_proposals_proposedWHEREstatus = 'Confirm Started'),Rejected AS (SELECTCOUNT(*) as rejected_numFROMdune.substrate.result_polkadot_proposals_proposedWHEREstatus = 'Rejected'),Confirmed AS (SELECTCOUNT(*) as confirmed_numFROMdune.substrate.result_polkadot_proposals_proposedWHEREstatus = 'Confirmed'),end_proposal AS (SELECTCOUNT(*) as end_numFROMdune.substrate.result_polkadot_proposals_proposedWHEREend_time IS NOT NULL),active AS (SELECTCOUNT(*) as active_numFROMdune.substrate.result_polkadot_proposals_proposedWHEREend_time IS NULL)SELECTvoting_num,confirming_num,end_num,active_num,