1SELECT 
2    SPLIT_PART(name, '.', -1) as tld,
3    COUNT(*) as domain_count,
4    COUNT(CASE WHEN tokenized_at IS NOT NULL THEN 1 END) as tokenized_count
5FROM "@blt.doma_testnet_core.names"
6GROUP BY tld
7ORDER BY domain_count DESC
8LIMIT 20