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

I'm adding required files for assignment 2:
-Assignment 2 - Bookstore Logical Model - Jesus Solis.pdf
-assignment2.sql

What did you learn from the changes you have made?

I learned how to write SQL queries addressing the following techniques to resolve some basic data manipulation and interpretation:
1. Window Functions for Ranking and Counting
2. String Manipulation Techniques
3. Joins and Cross Join Implications
4. Aggregations, Grouping, and Subqueries
6. Safe Use of Data Modification Statements

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?

The CROSS JOIN, the UNION and the last UPDATE exercise were challenging.

How were these changes tested?

I ran the queries against the provided Farmers Market DB.

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

Checklist

• I can confirm that my changes are working as intended