-- SELECT MIN(BLOCK_ID) MIN_BLOCK, MAX(BLOCK_ID) MAX_BLOCK, MAX_BLOCK-MIN_BLOCK, COUNT(DISTINCT BLOCK_ID)
-- FROM flipside_prod_db.polygon.transactions
SELECT MIN(BLOCK_NUMBER)::TEXT MIN_BLOCK, MAX(BLOCK_NUMBER)::TEXT MAX_BLOCK, (MAX_BLOCK-MIN_BLOCK)::TEXT "MAX-MIN", COUNT(DISTINCT BLOCK_NUMBER)::TEXT "COUNT_DISTINCT"
FROM polygon.core.fact_blocks