Learn how to filter data in SQL queries based on a range of values with the BETWEEN operator. Find out how to use it with numbers, dates, strings, and the NOT BETWEEN operator.

What is the bug? It seems SQL query engine doesn't honor what's configured in OpenSearch index mapping for date field. This causes problems in different queries with datetime field involved. See ex ...

In this lab, I applied additional filters to SQL queries to extract specific information from a database. I utilised standard SQL operators to filter data based on particular dates and times.