AN8 - Mini Project 2Query 1
Updated 2023-11-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT sales.buyer_address AS WALLET_ADDRESS,
meta.token_name AS wallet_name,sales.price AS token_price,
sales.block_timestamp AS Transaction_Date,
sales.tokenid AS token_ID,sales.project_name AS project,
sales.currency_symbol as Currency_Type,
meta.image_url
FROM ethereum.nft.ez_nft_sales AS sales INNER JOIN ethereum.nft.dim_nft_metadata AS meta
ON sales.tokenid=meta.token_id
WHERE meta.token_name LIKE '%fidenza%'
AND sales.currency_symbol = 'ETH'
ORDER BY sales.price DESC
LIMIT 1;
Run a query to Download Data