Show the current database

SELECT currentDatabase()

Instead of PostgreSQL you can write into two databases

SELECT count() FROM db.table

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/9639f9f7-240d-482f-a183-2d19879cdc12/Untitled.png

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

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/84977c32-10b1-4eca-a5c3-843179f5e6b4/Untitled.png

Creating Mat. Views