-- forked from UFC_Net_all @ https://flipsidecrypto.xyz/edit/queries/d681d187-24ff-49d1-9a76-75949cf014f8
SELECT COUNT(*) total_volume,
SUM(price) gross_sales
FROM flow.nft.ez_nft_sales
WHERE NFT_COLLECTION ='A.e4cf4bdc1751c65d.AllDay'
OR NFT_COLLECTION ='A.329feb3ab062d289.UFC_NFT'
OR NFT_COLLECTION ='A.0b2a3299cc857e29.TopShot'