PierandreaUntitled Query
Updated 2022-12-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
›
⌄
with sales as (SELECT
NFT_ASSET_ID as x,
BLOCK_TIMESTAMP::date as Date,
TOTAL_SALES_AMOUNT_USD
from algorand.nft.ez_nft_sales_fifa
WHERE SALE_TYPE = 'secondary'
AND TOTAL_SALES_AMOUNT_USD != '0'
order by 3 DESC
LIMIT 1 ),
rarity as (SELECT
NFT_ASSET_ID as y,
NFT_ASSET_NAME,
DROP_NAME,
ITEM_NO,
RARITY,
WORLD_CUP_TYPE,
COUNTRY_1_SCORE || '-' || COUNTRY_2_SCORE as Score,
EVENT_TYPE,
PLAYER,
MINUTE
--CONCAT('https://collect.fifa.com/marketplace/', LEFT(FullN,6)) as Website
from algorand.nft.ez_nft_metadata_fifa ),
merge as (select *
from sales
inner join rarity on sales.x = rarity.y)
select *
from merge
Run a query to Download Data