What changes are you trying to make?

• Created logical model for 2 tables in farmer's market database
• Completed prompts for parts 2 and 3 in the sql document
• Read article 'When Databases Get to Define Family ' and commented own experiences on how databases' function reflects societal value

What did you learn from the changes you have made?

• I am a lot more comfortable with the order at which SQL processes code lines
• The article was really interesting and made me think about how my name could have been different if database structure was different

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

• Play around more with aggregate types. use things like average, max and min
• play around more with outer/left/right merges

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

• SQL order of operations are not intuitive for me. I wrote a little cheat sheet to get my way through

How were these changes tested?

• run each line and see if the table matches expectations

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

Checklist

• I can confirm that my changes are working as intended