SELECT COUNT(Contract_Address) "Number of tokens launched on Ethereum"

FROM ethereum.core.fact_event_logs

WHERE ORIGIN_TO_ADDRESS='0x7603a35af5cf10b113f167d424eb75bb7062c8ce' AND

ORIGIN_FUNCTION_SIGNATURE = '0xfa18022c' AND EVENT_NAME='AuctionTimeUpdated'),

Project_On_BSC AS (

SELECT COUNT(Contract_Address) "Number of tokens launched on BSC"

FROM bsc.core.fact_event_logs

WHERE ORIGIN_TO_ADDRESS='0x5629ce74ddcad7cc72b3ea30444da7172ad851d9' AND

ORIGIN_FUNCTION_SIGNATURE = '0xfa18022c' AND EVENT_NAME='AuctionTimeUpdated'),

Project_On_Polygon AS (

SELECT COUNT(Contract_Address) "Number of tokens launched on Polygon"

FROM polygon.core.fact_event_logs

WHERE ORIGIN_TO_ADDRESS='0xc040f84cf7046409f92d578ef9040fe45e6ef4be' AND

ORIGIN_FUNCTION_SIGNATURE = '0xfa18022c' AND EVENT_NAME='AuctionTimeUpdated'),

Project_On_Avalanche AS (

SELECT COUNT(Contract_Address) "Number of tokens launched on Avalanche"

FROM avalanche.core.fact_event_logs

WHERE ORIGIN_TO_ADDRESS='0x438a2b1c6c715fb1b051c04ca65755560d8b8d43' AND

ORIGIN_FUNCTION_SIGNATURE = '0xfa18022c' AND EVENT_NAME='AuctionTimeUpdated'),

Project_On_Arbitrum AS (

SELECT COUNT(Contract_Address) "Number of tokens launched on Arbitrum"

FROM Arbitrum.core.fact_event_logs

WHERE ORIGIN_TO_ADDRESS='0x3db923fbab372ab8c796fef9bb8341cdb37cb9ec' AND

ORIGIN_FUNCTION_SIGNATURE = '0xfa18022c' AND EVENT_NAME='AuctionTimeUpdated'),

ALL_AUCTIONS AS (

SELECT 'Number of MISO auctions on Ethereum' AS TYPE, "Number of tokens launched on Ethereum" AS VALUE FROM Project_On_Ethereum

SELECT 'Number of MISO auctions on BSC' AS TYPE, "Number of tokens launched on BSC" AS VALUE FROM Project_On_BSC

SELECT 'Number of MISO auctions on Polygon' AS TYPE, "Number of tokens launched on Polygon" AS VALUE FROM Project_On_Polygon