Completed assignment 1 sql queries and write-up.

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

I wrote a series of SQL queries to address business needs. I also completed a write-up regarding value systems and databases.

What did you learn from the changes you have made?

I refamiliarized myself with introductory SQL concepts. The write-up also encouraged reflection upon value systems underpinning databases.

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

There were several different methods to write the more complex queries. I considered a variety of options. While benchmarking would probably be the most thorough approach, I instead focused on readability.

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

I am familiar with T-SQL, so reminding myself that this course uses SQLite was a challenge.

How were these changes tested?

I ran the code using DB Browser for SQLite.

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

Checklist

• I can confirm that my changes are working as intended