Assignment $-$ Run a query for a member listing based upon the VIEW you created in Module $8$ which will list members of the region whose NMRA membership expires in the next $60$ days. You may complete this assignment using either a simple SELECT statement, or using a VIEW.

IMPORTANT $$ This report should display the SAME COLUMNS as the Module $8$ report.

The Roster file you have been working with has the membership status as of $12/31/2023.$ The $$expires$$ column is the NMRA expiration date for the member.

The request is $$ we want to contact people whose NMRA memberships expire in the next $60$ days and remind them to renew their membership if they have not already. We want all REGION $($not just Division $9)$ members whose NMRA memberships end in the next $60$ days following the date of the report $($in this case, $12/31/2023).$ The report should have the same columns in it as the View you developed for Module $8.$

Note we must enter the date of interest into the VIEW$/$QUERY itself. In Module $14$ we will learn how to pass the report date into a stored function instead of having to change the query every month. You could use the CURDATE function, but you$$d have to run the report EXACTLY on the day you receive the monthly roster, so that is not a good option.