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

Understanding ClickHouse Replication and Sharding Keys