john-adamUntitled Query
Updated 2022-10-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with total_nft_ethereum as (select count(distinct nft_address)
from ethereum.core.ez_nft_sales)
, total_nft_ethereum as (select count(distinct nft_address)
from ethereum.core.ez_nft_sales)
, ethereum_allnft as (select sum(price) as s , nft_address
from ethereum.core.ez_nft_sales
group by 2
order by 1 desc)
, ethereum_allnft as (select sum(price) as s , nft_address
from ethereum.core.ez_nft_sales
group by 2
having s < 100
order by 1 desc)
select * from ethereum_allnft
Run a query to Download Data