ClickHouse tips #6: Filtering data in subqueries to avoid joins