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

Practicing our first SQL queries

What did you learn from the changes you have made?

I learned how to use SELECT, FROM, ORDER BY, LIMIT, WHERE, AND, BETWEEN, CASE and JOINS

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

Using ALIASES

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

Yes, I am still too novice to use ALIASES and wildcard characters for more efficient code

How were these changes tested?

Running ALL the queries in DBBrowser (SQ Lite), looking for errors and outputs

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

N/A

Checklist

• I can confirm that my changes are working as intended