1SELECT 
2    COUNT(*) as expiring_domains,
3    SPLIT_PART(name, '.', -1) as tld
4FROM "@blt.doma_testnet_core.names"
5WHERE expires_at BETWEEN CURRENT_TIMESTAMP AND CURRENT_TIMESTAMP + INTERVAL '30 days'
6GROUP BY tld
7ORDER BY expiring_domains DESC