1SELECT 
2    COUNT(*) as total_active_listings,
3    COUNT(DISTINCT name) as unique_names_listed,
4    AVG(price_adj) as avg_listing_price,
5    MIN(price_adj) as floor_price,
6    MAX(price_adj) as ceiling_price
7FROM "@blt.doma_testnet_core.listings"
8WHERE expires_at > CURRENT_TIMESTAMP
9