Converting ClickHouse Results to pandas DataFrames with Column Names

How to Write a Complex Clickhouse SQL Query for Sum of Values Based on Specific Conditions