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

Adding the completed assignment2.sql file and an accompanying PNG file showing diagrams.

What did you learn from the changes you have made?

I practiced SQL skills, including COALESCE, window functions, string manipulation, UNION, and data modification commands (INSERT, DELETE, UPDATE).

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

I considered different ways of structuring the queries, but I chose the most straightforward and efficient ones based on the assignment instructions.

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

Yes, I faced some difficulties with certain window functions, but I reviewed the examples provided in the course material and tested multiple queries until I found the correct approach.

How were these changes tested?

I ran all SQL queries in my database environment and verified that the outputs matched the expected results.

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

N/A

Checklist

• I can confirm that my changes are working as intended