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

Focused on techniques as COALESCE, window functions, string manipulations, and UNION queries, expanding the database with new tables and inserting, deleting, and updating data.

What did you learn from the changes you have made?

How to handle complex SQL queries and database modifications effectively. I gained insights into advanced SQL functions, such as COALESCE and window functions, and understood their practical application.

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

For the ethical and equity considerations, I also thought about incorporating automated checks for potential biases in data analysis.

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

One challenge was dealing with NULL values in the product table while using the COALESCE function. Understanding how to replace NULL values without affecting non-NULL entries required careful handling.

How were these changes tested?

These changes were tested by executing the SQL queries on the farmersmarket.db and verifying the results against expected outcomes.

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

Checklist

• I can confirm that my changes are working as intended