What changes are you trying to make? (e.g. Adding or removing code, refactoring existing code, adding reports)

Refactoring queries and adding filtering for customer purchases.

What did you learn from the changes you have made?

Optimized query structure and better data filtering with strftime.

Was there another approach you were thinking about making? If so, what approach(es) were you thinking of?

Considered using subqueries but stayed with aggregations for simplicity.

Were there any challenges? If so, what issue(s) did you face? How did you overcome it?

Faced formatting issues with dates but resolved using strftime.

How were these changes tested?

Executed SQL queries and reviewed the output manually.

A reference to a related issue in your repository (if applicable)

No.

Checklist

• I can confirm that my changes are working as intended