What changes are you trying to make?

Added a logical model, queries, and reflection about ethics and inequity for homework 1-6

What did you learn from the changes you have made?

I learned how to use SQL queries like SELECT, WHERE, CASE, JOIN, AGGREGATE, GROUP BY, COALESCE, SUM, DROP TABLE, ROW_NUMBER(), DENSE_RANK(), and string functions such as SUBSTR and INSTR. This strengthened my ability to clean and analyze data using SQL, as well as combine results from different queries with UNION. Additionally, I practiced creating tables, inserting records, and updating data, further expanding my database management skills.

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?

I faced challenges in effectively combining the queries

How were these changes tested?

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

Checklist

• I can confirm that my changes are working as intended