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

Uploading my assignment 2.

What did you learn from the changes you have made?

Basically everything in here was new knowledge to me, given it was my first experience with advanced SQL.

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

I came up with several (inferior) answers for the UNION and CROSS-JOIN questions, but they were too long.

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

ALTER TABLE question was very difficult. I couldn't get this just from reviewing the slides, so I had to look up (a) where to implement coalesce() and (b) how to structure the WHERE command.

How were these changes tested?

Just trial and error in the SQLite execute window.

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

Checklist

• I can confirm that my changes are working as intended