Hey how do I combine two clickhouse queries

Question

Srikanth Chekuri · Answer

You can write a single ClickHouse query that combines the result of two queries by using subqueries

Harshith.R.S · Answer

Can you give me an example

Vishal Sharma · Answer

You can use `WITH` to write subqueries here s example <https onelinerhub com clickhouse using subqueries in with queries>

Vishal Sharma · Answer

Also I am curious to know why you had to write clickhouse query For most of queries query builder works Have you tried query builder

Harshith.R.S · Answer

It says I ve exhausted the amount of panels that can be created using query builder

Vishal Sharma · Answer

You can upgrade to paid plan which will offer unlimited panels alerts and more advanced features

Harshith.R.S · Answer

where can I check what features are available for free plan