with AVG_DAYS AS ( SELECT AVG(tx_count) AS AVG_TXS from avalanche.core.fact_blocks

),

MEDIAN AS ( SELECT DISTINCT PERCENTILE_CONT(0.5)

WITHIN GROUP(ORDER BY tx_count) OVER() AS MEDIAN

FROM avalanche.core.fact_blocks),

MODE AS (

SELECT TOP 1 tx_count AS MODE

FROM avalanche.core.fact_blocks

GROUP BY tx_count

ORDER BY COUNT(*) DESC)

SELECT AVG_TXS as "Average transactions per block", MEDIAN as "Median transactions per block", MODE as "Mode" FROM AVG_DAYS

JOIN MEDIAN

JOIN MODE