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

• Adding a jpeg file containing the table relationships
• Adding a "section 4" containing my essay-like response
• Adding an sql file containing my answers for sections 2 and 3

What did you learn from the changes you have made?

• I'm more comfortable with git
• SQL is easier than I thought after working with matlab and python. It's quite straightforward. I particularly like the temp table feature.

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

• Hmm, for the last question (I believe) I used a temp table. I wondered about how to answer that without a temp table?

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

• I wrote it in the sql document, but I struggled with the second aggregate question using join.
• This is what I wrote there: "In my mind, if I couldn't see the tables attached after join, they weren't joined. As a result I simply wasn't trusting that group by and having were working. However, I manually verified that this result was correct."

How were these changes tested?

• Hmm, I tested the tables by making great use of the browse-data and constantly mini-checking using select by to see what each step was producing
• For my changes in git, I kept double checking that my work was saved in the correct branch and showed up here after I did git push.

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

• Mm, no issues off the top of my head.

Checklist

• I can confirm that my changes are working as intended