1SELECT 
2    SPLIT_PART(name, '.', -1) as tld,
3    MIN(price_adj) as min_price,
4    PERCENTILE_CONT(0.25) WITHIN GROUP (ORDER BY price_adj) as p25_price,
5    PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY price_adj) as median_price,
6    PERCENTILE_CONT(0.75) WITHIN GROUP (ORDER BY price_adj) as p75_price,
7    MAX(price_adj) as max_price,
8    COUNT(*) as sample_size
9FROM "@blt.doma_testnet_core.listings"
10WHERE expires_at > CURRENT_TIMESTAMP
11    AND UPPER(SPLIT_PART(name, '.', -1)) != 'APE'
12GROUP BY tld
13HAVING COUNT(*) >= 10
14ORDER BY median_price DESC