Farmer's market query (SELECT, WHERE, CASE, JOIN queries)

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

The queries retrieve data from the database and sorts it.

What did you learn from the changes you have made?

The changes show how data can be accesses and read bases on specific commands/queries.

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

Not necessarily a different approach, but I had to learn to understand the data in the database in order to access it and use it.

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

Learning experience, more than a challenge.

How were these changes tested?

The changes were tested one query at the time.

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

By now, I see which steps repeat in creating my repository and what is course specific when I access it.

Checklist

• [ x] I can confirm that my changes are working as intended