1SELECT 
2    COUNT(*) as total_active_offers,
3    COUNT(DISTINCT name) as unique_names_with_offers,
4    AVG(price_adj) as avg_offer_price,
5    MAX(price_adj) as highest_offer
6FROM "@blt.doma_testnet_core.offers"
7WHERE expires_at > CURRENT_TIMESTAMP