Comparing the year data in two columns of a table?

[w0sk]

Hello teachers. In my database, I am retrieving products and their compatible year ranges in two different ways. However, users are searching with only one year data while selecting products. I am unsure how to find if this selected year is between these two data points. I couldn't write the SQL query. Table: For example, if a user selects the year 2015, I should be able to retrieve data between the years 2014 and 2018.