1SELECT 
2    name,
3    MAX(price_adj) as best_offer,
4    currency_symbol,
5    COUNT(*) as total_offers,
6    SPLIT_PART(name, '.', -1) as tld
7FROM "@blt.doma_testnet_core.offers"
8WHERE expires_at > CURRENT_TIMESTAMP
9GROUP BY name, currency_symbol, tld
10ORDER BY best_offer DESC
11LIMIT 30