SQL for count of items returned both during and after library's grace period?


One of the libraries in this consortia started a 14 day grace period at the time of the COVID lockdowns. They are trying to gather information to help review their current fine structure and have two questions:

#1 How many total overdue items were returned within the grace period in 2021, 2022, and 2023 (1/1-6/30/23)? If possible, they would also like this broken out by collection name and material type.

#2 How many patrons returned overdue items after the grace period for the same time period? They would also like this broken out by patron code.

They are only looking for total counts - not specific item or patron details.

Thank you in advance for any assistance you can provide.