clickhouse code snippets in typescript

write a select query for clickhouse in typescript