What kind of conditions can we chain with AND?

Any kind, including conditions with BETWEEN, LIKE, and INOnly conditions with comparisons like =, <, >

Any kind, including conditions with BETWEEN, LIKE, and IN.