How to iterate over certain rows in sqlite3 in Python?

Question

Python

There is a database on SQLite3 with which the Python3 script works.
The database table has a date column, i.e. each line has its own date in the format "4/11/2021". I need to go through in a for loop all rows that have dates of the fourth month, i.e. end with "4.2021", and get the data I need from the strings.
Help, please)))) How to find rows whose date column ends with "4.2021"?

Answer 1

where date between 01-04-2021 and 30-04-2021