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

Converting ClickHouse Results to pandas DataFrames with Column Names