1SELECT 
2    SPLIT_PART(name, '.', -1) as tld,
3    MIN(price_adj) as floor_price,
4    COUNT(*) as listing_count,
5    currency_symbol
6FROM "@blt.doma_testnet_core.listings"
7WHERE expires_at > CURRENT_TIMESTAMP
8GROUP BY tld, currency_symbol
9HAVING COUNT(*) >= 5
10ORDER BY floor_price ASC
11LIMIT 20