More on the WHERE Clause

The “between” keyword is important in the WHERE clause:

SELECT *

FROM database_table

WHERE Total Speakers between 200,000,000 and 500,000,000

The “between” keyword is very useful — above it will return all rows that have Total Speakers above 200 mn and below 500 mn, so rows numbered 5 through 10. You can also use the “between” keyword on dates, such as “date between 02-01-2023 and 02-10-2023” to return data with dates between Feb 1, 2023 and Feb 10, 2023 (if that database table had a date column as well).