WITH volume_in_sol AS (

SELECT

mint,

SUM(sales_amount) AS volume_in_sol

FROM

solana.nft.fact_nft_sales

WHERE

block_timestamp BETWEEN '2024-09-01' AND '2024-09-30'

GROUP BY

mint

),

sol_price AS (

SELECT

AVG(price) AS average_price

FROM

solana.price.ez_prices_hourly

WHERE

hour BETWEEN '2024-08-31 00:00:00' AND '2024-09-18 23:59:59'

AND

token_address = 'So11111111111111111111111111111111111111112'

SELECT

CASE

WHEN v.mint = 'rFqFJ9g7TGBD8Ed7TPDnvGKZ5pWLPDyxLcvcH2eRCtt' THEN 'rFqFJ9g7TGBD8Ed7TPDnvGKZ5pWLPDyxLcvcH2eRCtt'

WHEN v.mint = 'BM4gMVksVm2iRexKdMNVLhyq981bwwhFutuiZixvJcDj' THEN 'SMB #2707'

WHEN v.mint = '7SoT67focyc9i6ypotFRwcQaZU74TvCJN3fEWgNUj2G' THEN 'SMB #2776'

WHEN v.mint = 'FWBwUWCRYgnpZSeoKjrJ6HAoqFVa91EfM9aaoX8mRcq9' THEN 'SMB #3944'

WHEN v.mint = 'BAAzgRGWY2v5AJBNZNFd2abiRXAUo56UxywKEjoCZW2' THEN 'SMB #1989'

WHEN v.mint = 'BG22u7Fw8mrPfo43ndrwJPXSCmE3q535xJizTCUWQUoa' THEN 'SMB #2272'

WHEN v.mint = 'Df1tqcvcstRsTwH6nN9P8vN4WzzZZWsw75puEdY86X4B' THEN 'SMB #2083'

WHEN v.mint = '8udN5Lsu1t4fVi6h6VF9DVwCEocodVk7V9DgpAZYLwTa' THEN '8udN5Lsu1t4fVi6h6VF9DVwCEocodVk7V9DgpAZYLwTa'

WHEN v.mint = '6q4pySftZxAv6t8CNoRqvyyvYR3wkYnUPNijV6mGH7gN' THEN 'SMB Gen2'

WHEN v.mint = '5ngd2EQz1y4G4xeWRqGUsAr9Tu7zFfTqeXjC8gqaxnjN' THEN 'SMB #2750'