What changes are you trying to make?

Adding the assignment1.sql file with completed queries and the assignment1.png diagram showing the logical model for two tables.

What did you learn from the changes you have made?

I practiced basic SQL commands including SELECT, JOIN, WHERE, CASE, and aggregate functions, and I reviewed how to build a logical data model.

Was there another approach you were thinking about making?

Not for this assignment. I followed the requested format and structure.

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

I initially encountered an error when trying to push to a non-existent branch and when dealing with temp tables in SQLite. I resolved it by properly creating a branch and adjusting SQL syntax to match SQLite requirements.

How were these changes tested?

I executed the SQL queries inside SQLite and verified that they returned the expected results. The logical model diagram was cross-checked with the table structure.

A reference to a related issue in your repository

N/A

Checklist

• I can confirm that my changes are working as intended