These SQLs are created considering today's date as base. So you can take a fresh copy from here ( every day ) and use the same to test your query.
Use the below query to create table in MysQL workbench or PHPMyAdmin and add records for duration ( + and - )370 days from today.
Records of different date ranges by using DATE_SUB(), CURDATE() and BETWEEN() query.
Use this to add records for query in the range of 3 months to 12 months.