COUNT(DISTINCT tx_id) AS "Total Bridges",

COUNT(DISTINCT user_address) AS "Total Bridgers",

COUNT(DISTINCT mint) AS "token sent for bridging",

COUNT(DISTINCT platform) AS "total platforms involved in bridging",

COUNT(DISTINCT CASE WHEN succeeded ='True' THEN tx_id END) AS "successful bridges",

COUNT(DISTINCT CASE WHEN succeeded ='False' THEN tx_id END) AS "failed bridges",

COUNT(DISTINCT CASE WHEN direction ='inbound' THEN tx_id END) AS "inbound bridges",

COUNT(DISTINCT CASE WHEN direction ='outbound' THEN tx_id END) AS "outbound bridges",

FROM solana.defi.fact_bridge_activity

block_timestamp > '2024-08-31'AND block_timestamp < '2024-10-01'