@UofT-DSI

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

Adding sql files to execute for assignment one

What did you learn from the changes you have made?

How to use DB SQLite, how to run SQL conditions and commands on an existing database.

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

I am still learning what join to use between tables. I was thinking of experimenting with different JOINS

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

Writing subqueries and understanding what the error messages meant. Syntax could mean something as adding a comma or semi-colon to my code.

How were these changes tested?

Running and re running code.

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

Checklist

• I can confirm that my changes are working as intended
• Create a branch called assignment-one.
• Ensure that the repository is public.
• Review the PR description @guidelines and adhere to them.
  Verify that the link is accessible in a private browser window.