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

modified the Assignment2.md for answering the type1 and type2 SCD
added 2 png for ERD
modified the Assignment2.sql for SQL questions

What did you learn from the changes you have made?

more familiar with the windowed functions

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

was using with clause on most of the SQL Questions, but probably can use temporary tables
some of the Question that use the windowed functions that probably can use max and min inline query to get the same reason

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

no big challenges. it is more like google for the syntax of the SQL

How were these changes tested?

the changes was testing section by section like test each of the with clause first and cross check manually with list out the reason if their output as expected.

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

I guess the problem I branch out from assignment-one branch, so the pull request from assignment-two to main. it also included assignment-one changes.

Checklist

• [YES] I can confirm that my changes are working as intended