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

I have added the appropriate SQL queries so that we can easily find out rows that fit certain criteria and specifications.
I filtered, aggregated, and joined data across tables to achieve the homework specifications.

What did you learn from the changes you have made?

I learned that joining is a powerful tool to get the specific results you want, especially if you can do an inner join.
In addition, I learned about strftime() to extract certain parts of a date in SQLite.

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

I utilized join in some commented parts of my code to try using vendor_name instead of vendor_id, because it was more informative to have vendor_name.

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

Understanding strftime() was a bit challenging, but the slides and a google search was able to help me overcome the challenges.

How were these changes tested?

They were tested in DB browser to test that the results made sense based off of the original tables that were used in the query.

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

Checklist

• I can confirm that my changes are working as intended