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

Understanding the LIKE Operator in ClickHouse: Workarounds for String Matching Challenges