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 201SELECT
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 20Share link
Anyone who has the link will be able to view this.