OK now I want to construct simple, tp query

What this is?

where is syntax explained?

Sorry if this is unclear. What kind of data source are you using? Redash just passes your query directly to the database. So if you’re using Postgres you write postgres syntax, mysql == mysql etc. There are some exceptions for things like cloudwatch which uses a YAML style syntax that’s covered in the docs.