flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Untitled Query
msafadoost
Untitled Query
Updated 2022-07-22
Copy Reference
Fork
9
1
2
3
4
5
6
›
⌄
SELECT
MOMENT_DESCRIPTION
,
sum
(
PRICE
)
FROM
flow
.
core
.
dim_topshot_metadata
JOIN
flow
.
core
.
fact_nft_sales
USING
(
NFT_ID
)
WHERE
PLAY_TYPE
=
'Rim'
GROUP
by
1
HAVING
(
max
(
sum
(
PRICE
)
)
)
--ORDER by sum(PRICE),
Results
Run a query to Download Data