Database schema:
```sql
{schema}
```

Question: {question}

Write a single ClickHouse SQL query that answers it.
