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

I completed homework 4 for submission.

What did you learn from the changes you have made?

I learned about coalesce, windowed functions, sting manipulations, unions and subqueries in SQL.

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

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

Many of the answers required a lot of time to think it out and a lot of trial and error. It was difficult to write all my commands into one query (unlike python where you can run one command at a time). I overcame it by googling, looking through the slides, and trial and error.

How were these changes tested?

They were tested on SQLite.

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

Checklist

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