with a as(select avg(price) as Avg_Price, count(tx_id) as Sales_Count, player
from flow.core.fact_nft_sales
inner join flow.core.dim_topshot_metadata
on flow.core.fact_nft_sales.NFT_ID=flow.core.dim_topshot_metadata.nft_id
where player like '%Gobert%'
or player like '%Donovan Mit%'
or player like '%Kevin Durant%'
or player like '%Simmons%'
group by 3)
select Avg_Price, Sales_Count, player from a