#What changes are you trying to make? (e.g. Adding or removing code, refactoring existing code, adding reports)
-Completed Assignment 1 covering SQL fundamentals and logical data modeling:
SQL queries: SELECT, WHERE, CASE, JOIN, Aggregates, Temp Tables.
Logical data model diagram showing vendor to vendor_booth_assignments relationship (1:∞).

#What did you learn from the changes you have made?
-SQL query optimization and multiple filtering approaches.
-Table relationships through JOIN operations and primary/foreign keys.
-Conditional logic with CASE statements and data flagging.
-Data aggregation with GROUP BY and HAVING clauses.
-Temporary table creation and data manipulation.
-Entity relationship diagramming for database design.

#Was there another approach you were thinking about making? If so, what approach(es) were you thinking of?
-For the vendor booth count, thought about using COUNT with DISTINCT but realized COUNT(*) was more appropriate.
-For temp table creation, contemplated using CREATE TABLE with explicit column definitions instead of SELECT *.

#Were there any challenges? If so, what issue(s) did you face? How did you overcome it?
-Temporary Tables: Initially faced issues with temp table persistence across sessions; resolved with proper session management

#How were these changes tested?
-Confirmed temp table operations by querying the created tables.

#A reference to a related issue in your repository (if applicable)
-N/A - This is the initial submission for Assignment 1.

Checklist
[ x] I can confirm that my changes are working as intended
[ x] All queries execute without errors