ClickHouse supports a declarative query language based on SQL that is identical to the ANSI SQL standard in many cases. Supported queries include GROUP BY, ORDER BY, subqueries in FROM, JOIN clause,
