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.
Video Tutorial on Date Query using CURDATE, BETWEEN , YEAR, MONTH, DAYOFWEEK()
Use this to add records for query in the range of 3 months to 12 months.