-- Query: Summary: active hosts by type
-- Result variable: host_type_summary

SELECT
    COALESCE(conversation_type, 'Web') AS conversation_type,
    COUNT(DISTINCT host_id) AS host_count,
    SUM(tool_message_count) AS total_tool_messages
FROM active_hosts_by_type
GROUP BY COALESCE(conversation_type, 'Web')
ORDER BY host_count DESC