flipside

    Total yeeting attemp
    therealestberaTotal yeeting attemp
    Updated 2024-08-26

    -- Get started with Flipside by running your first query:
    -- the SQL statement below will get you a list of NFT
    -- platforms on Ethereum, ranked by how many sales
    -- they've had in the past month.

    -- Be sure to see our documentation for more guidance,
    -- including a full walkthrough of the app:
    -- https://docs.flipsidecrypto.xyz/our-app/getting-started

    select
    Count(TX_SUCCEEDED),
    SUM(CASE WHEN TX_SUCCEEDED = 'TRUE' THEN 1 ELSE 0 END) AS TRUECOUNT,
    SUM(CASE WHEN TX_SUCCEEDED = 'FALSE' THEN 1 ELSE 0 END) AS FALSECOUNT
    from berachain.testnet.fact_transactions
    where TO_ADDRESS = LOWER('0x14D65204c710997F595F4663f0451b66d3532f53')
    and INPUT_DATA='0x8bbefe4b'



    QueryRunArchived: QueryRun has been archived