SELECT DISTINCT *

FROM (

VALUES ('0xfec90bc707fc93aefeb0c18c2eb56bc79d32163e'),('0x91ac106090fe2b0fa7d01efdf4487a5bfafad7fa'),( '0x7e680862c572e4b945cf45912130c8d884109b59'),(

'0xd5ae5a16fbaf964f96e242645a4a6f10b98fd0c4'),( '0x37db2523d221d19838632eb62d1af911e52632c3'),( '0x5fd4d6fef3b87b91c7df8658727b5edd7210cf5a'),( '0x45ee1caed83525673843321107bccadecb9065d7'),(

'0xe1b5e23fdbc003aec16e6e79726a0b5f75ff93f5'),( '0xbcea6c4029203b8753c856a2514a6ed211c69777'),( '0x334ad326a787dd332f26cbe8b4d7adfa8bd25f92'),( '0xbc096988fa38c78d65c0637453fd3d3c38b1cfd4'),(

'0x0985cb10c5d57dbf44aa473f33839ed38d80f111'),( '0x3e4627665bf2e52c69be03788e664ab545f2be71'),( '0x04f7a676af597f847053b6c02ed42d02fa4046aa'),( '0x79ef499463dae3cd413d78477fa848ecbbda774b'),(

'0x81ba34b90876f42f34a4f232cfc0fe4b6ec949a3'),( '0x621ce7e7e44d43a428a183d5390c4f4572c9ff9d'),( '0x04125a97a0f2583cd485be2c34b651cc13c38a27'),( '0xdaa6e4ba2d4022ed820460bb501b9e061d9614fb'),(

'0x3458161f2dc5d7eafa48e7c8d9acd7f415cf6da6'),( '0x04f087e3191d7a050800a2e04cb20046d2633e35'),( '0x8264e2bad3d2f7afd72a00233b9f841fe4b388cd'),( '0xddbdb65138131dbf2d01b4a5140e1979680c90bb'),(

'0xc70a7496716b3e25546901fe88215531abbd5a10'),( '0x2e90e8af4c319095942c84cfa446e1f206795517'),( '0x150afa2dfcaaada471472dfa6ad4b79e718a197c'),( '0x83feea011baeb1c6d1df7d23903efad83d3c781f'),(

'0x21d426e2b88fbf8b93adf0591a2d5b08d58f089f'),( '0xe4989961ebfdac3e65fcf0059c916452c77d8503'),( '0x6acb8fb82880d39c2b8446f8778a14d34ee6cfb7'),( '0xbfd670667053e517a97afe56c91e4f83f1160bd3'),(

'0xb9c042c3275bc49799688eea1a29b1405d02946b'),( '0x466a330887bdf62d53f968ea824793150f07762e'),( '0x5846728730366d686CdC95dae80a70b44Ec9eAb2'),( '0xfbed9640e37666fe2ac78e1d263670976354cb69'),(

'0xe0743141df04a6b9f3df890429cc994e46db03d9'),( '0x97439ee4c93ff9f76417696ce648aa6f35ab3b25'),( '0xf43bc3f4f1edb7d4c373c8510a2888d69d83ceb7'),( '0x425bf054ef7bad65b7bdd8e6587b1c3500e4f4ca'),(

'0x2956409293da98603025cc0121c06a4244752039'),( '0xa7bb50d90b43752199c45be04053641c3cb5f53f'),( '0x47749c5b970e63f3a0ed57cd6cef773e74fafe9d'),( '0x838c1cd42929543daf9c3ef294fee8c1b3224b37'),(

'0xc5aa1f91b0d52e26d2847f8e51f505d6e2ece795'),( '0xee1ee80338958fa596471ceb70f0177daff80323'),( '0x4670e4890bc1b76f3ae5c7660aa98e0b6668c6f3'),( '0x2d58a44d6c0a355de25761fb33a1f6269a97e2c5'),(

'0xd8cf23bf309de778609d234bd2410b0156118c26'),( '0x91e51b92a2efea89bf1b6f66ad719737264724be'),( '0xd6261320f49d38c137f6e229a2ea4ab0f4fae6de'),( '0xfc190440e8f357ffe8a75940e7d8a291e165d019'),(

'0x808ed3e23aac685126524aa4416d8eaeb2e767b9'),( '0x65a83530ca8abc27969907913fe5e641a5da2e9f'),( '0x6d1c3646e8cce8537e6ec9ecab26762bfaf1f891'),( '0x63e2f0c058ce9a194ec68f04320b7eb8ca555bd3'),(

'0x45308788743bbdae5de7ba9e565c0502d0ebb81f'),( '0x907808732079863886443057c65827a0f1c64357'),( '0x8d0501d85becda92b89e56177ddfcea5fc1f0af2'),( '0x6ad08588568e258b2bdf065e7769fce398f68a1c'),(

'0x946ad8e53db653053e8ef7c02dfca83ce8ba8022'),( '0x27b37e4befacc50b02102d1e2117c4ea8a54beff'),( '0x71dc46607f31f30510f0ccc670b0963f431b212a')

) AS X(con)

, final as (

select 'Reddit NFTs' as collection,

event_inputs:_from ,

count (distinct tx_hash) as Sales_Count,

count (distinct event_inputs:_to) as Buyers_Count,

count (distinct event_inputs:_id) as Tokens_Count

from polygon.core.fact_event_logs

join contracts on contract_address = con

and event_name ='TransferSingle'

and tx_status = 'SUCCESS'

and event_inputs:_from != '0x0000000000000000000000000000000000000000'

group by 1, 2

union all