rashmannbumpy-blush
    Updated 2024-10-08
    SELECT
    COUNT(*) AS total_transactions,
    COUNT(CASE WHEN STATUS = 'success' THEN 1 END) AS successful_transactions
    FROM
    base.core.fact_transactions;
    WHERE
    BLOCK_TIMESTAMP >= '2023-09-01' AND BLOCK_TIMESTAMP < '2023-10-01';

    QueryRunArchived: QueryRun has been archived