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

I added a logical model inside 02_activities > assignments > images. I also added my answers to Section 1 & 4 of the Assignment1.md file. Lastly, I added requested queries (answering Section 2 & 3) inside assignment1.sql file.

What did you learn from the changes you have made?

I learned how to write queries in SQL using commands like SELECT, JOIN, FROM; filter data using HAVING, WHERE; aggregate data using various aggregate functions like sum, avg.

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?

No particular challenges. I am still trying to get more familiar with the order of the commands (SELECT > FROM > JOIN > WHERE). Especially with the various filtering, sorting and ordering functions, I'm still not quite clear how they should be ordered.

How were these changes tested?

I ran the queries in DB Browser to make sure the resulting output matched the descriptions.

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

NA

Checklist

• I can confirm that my changes are working as intended