SELECT TOKENID, AVG(Price) AS AvgSalePrice

FROM ethereum.nft.ez_nft_sales

WHERE currency_symbol LIKE 'ETH%'

GROUP BY TOKENID

SELECT Metadata.TOKENID, Metadata.TOKENID_NAME, Sales.AvgSalePrice

FROM ethereum.nft.dim_nft_collection_metadata AS Metadata

JOIN ArtworkSales AS Sales ON Metadata.TOKENID = Sales.TOKENID

WHERE Metadata.TOKENID_NAME LIKE 'BOONJI%'

LIMIT 50

select TOKENID, PRICE

FROM ethereum.nft.ez_nft_sales

WHERE TOKENID = '3532'

WITH SalesRanking AS (

SELECT TOKENID, RANK() OVER (ORDER BY COUNT(TOKENID) DESC) AS SalesRank

FROM ethereum.nft.ez_nft_sales

GROUP BY TOKENID

SELECT Metadata.TOKENID, Metadata.TOKENID_NAME, Ranking.SalesRank

FROM ethereum.nft.dim_nft_collection_metadata AS Metadata

JOIN SalesRanking AS Ranking ON Metadata.TOKENID = Ranking.TOKENID

WHERE Metadata.TOKENID_NAME LIKE 'BOONJI%';

WITH MaxSaleInfo AS (

SELECT TOKENID, MAX(Price) AS MaxSalePrice

FROM ethereum.nft.ez_nft_sales

GROUP BY TOKENID

SELECT Metadata.TOKENID, Metadata.TOKENID_NAME, MaxSale.MaxSalePrice, Sales.BUYER_ADDRESS

FROM ethereum.nft.dim_nft_collection_metadata AS Metadata