Mastering the `%between%` Function in `data.table`: A Guide to Efficient Data Subseting

How to Use the BETWEEN Clause Effectively for Filtering Out Overlapping Datetime Fields in SQL