flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
bumpy-blush
rashmann
bumpy-blush
Updated 2024-10-08
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
›
⌄
⌄
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'
;
Results
QueryRunArchived: QueryRun has been archived