select query code snippets in typescript

write a select query for clickhouse in typescript