therealestberaTotal yeeting attemp
Updated 2024-08-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- 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