SELECT
t.NFT_ADDRESS,
t.project_name,
AVG(PRICE_USD) AS AVG_SALES_USD,
MAX(PRICE_USD) AS MAX_SALES_USD
FROM
ethereum.nft.ez_nft_sales t
WHERE
t.NFT_ADDRESS = lower('0xBd3531dA5CF5857e7CfAA92426877b022e612cf8')
OR t.NFT_ADDRESS = lower('0xBC4CA0EdA7647A8aB7C2061c2E118A18a936f13D')
GROUP BY
t.NFT_ADDRESS, t.project_name;