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

I have completed all required queries in assignment1.sql for the farmersmarket.db dataset and added a logical model diagram showing the customer and customer_purchases tables with their relationships. This includes solutions for WHERE, JOIN, AGGREGATE, and DATE section prompts.

What did you learn from the changes you have made?

I learned how to use SQLite functions such as strftime for date extraction, CASE statements for conditional columns, and HAVING with aggregate functions. I also reinforced my understanding of one-to-many relationships in a database and how to represent them in a logical model.

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

There are many ways to write the same query, but this seemed the easiest way to do it.

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

I had to adjust my logic in some of the queries, also since the date section was not requeried but I wanted to do it, I had to brush up the strftime concept.

How were these changes tested?

Each query was run directly against farmersmarket.db in the SQLite CLI to verify that the output matched the assignment requirements. I also ran the full assignment1.sql file to confirm there were no syntax errors and that all queries executed correctly.

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

None

Checklist

I can confirm that my changes are working as intended YES

I have verified that all queries return the correct results YES

I have included the logical model diagram in this branch YES