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

Completed all the tasks in all the sections for assignment-two

What did you learn from the changes you have made?

How to use advanced SQL queries to accomplish data extraction tasks

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

Some of the tasks could be completed in other ways that are more efficient but due to time limitation, I did not experiment too much on making the queries more efficient.

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

O yes. I took me some time, many hours to full understand each task and write the SQL queries. Finally, I did it, I think!

How were these changes tested?

I ran the queries and checked the output visually.

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

NA

Checklist

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