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

Designing a logical model for a book store, using SQL to interact with a database and perform various operations to summarie tables and create a new one. With individual records, I had to use window functions to perform these actions (i.e. insert, trim, union, cross/inner/union joins).

What did you learn from the changes you have made?

I've learned how to use windowed functions, joins, and how to change/update data tables in SQL.

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

There were different combinations of using joins, group bys and unions - I tried to use what worked without too much redundant work.

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

I had challenges figuring out what is the most efficient way to complete certain tasks.

How were these changes tested?

Tested locally.

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

Checklist

• I can confirm that my changes are working as intended