COUNT(DISTINCT CASE WHEN block_timestamp >= '2023-01-01' AND block_timestamp < '2024-01-01' THEN tx_signer END) AS "Total Users 2023",

COUNT(DISTINCT CASE WHEN block_timestamp >= '2024-01-01' AND block_timestamp < '2025-01-01' THEN tx_signer END) AS "Total Users 2024",

ROUND(

(COUNT(DISTINCT CASE WHEN block_timestamp >= '2024-01-01' AND block_timestamp < '2025-01-01' THEN tx_signer END)

- COUNT(DISTINCT CASE WHEN block_timestamp >= '2023-01-01' AND block_timestamp < '2024-01-01' THEN tx_signer END))

* 100.0

/ NULLIF(COUNT(DISTINCT CASE WHEN block_timestamp >= '2023-01-01' AND block_timestamp < '2024-01-01' THEN tx_signer END), 0),

2

) AS "Percentage Growth (%)"

FROM near.core.fact_transactions;