Show the current database

SELECT currentDatabase()

Instead of PostgreSQL you can write into two databases

SELECT count() FROM db.table

Clickhouse has a variety of different datetime functions: https://clickhouse.tech/docs/ru/sql-reference/functions/date-time-functions/

Aggregations

Standard as avg / min / max / sum, and native to CH such as uniq(), quantile()

JOINS

Creating Mat. Views