Elements of a SQL Query

Hi, so I learn better by knowing all the elements of the topic I’m learning, like “the big picture”, in this case I want to know the elements of a SQL query, I have the following:

• Statements: select, from, order by
• Operators: as, or, in
• functions (here we have scalar and aggregate): count, sum, min, cast

I don’t know if I’m missing something, also I don’t know how the AND and BETWEEN - AND are catalogued

Thank you all!