flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
2024-03-20 03:52 PM
aycg
2024-03-20 03:52 PM
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
project_name
,
creator_fee_usd
FROM
ethereum
.
nft
.
ez_nft_sales
s1
WHERE
EXISTS
(
SELECT
1
FROM
ethereum
.
nft
.
ez_nft_sales
s2
WHERE
s2
.
creator_fee_usd
>
100
AND
s1
.
project_name
=
s2
.
project_name
)
;
Results