Skip to content

[approved] Assignment two#2

Open
yikai82 wants to merge 41 commits intomainfrom
assignment-two
Open

[approved] Assignment two#2
yikai82 wants to merge 41 commits intomainfrom
assignment-two

Conversation

@yikai82
Copy link
Copy Markdown
Owner

@yikai82 yikai82 commented Aug 18, 2025

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

Try to complete SQL - assignment 2 by following the instructions:

  • Uploaded assignment2.sql
  • Uploaded Bookstore.png

What did you learn from the changes you have made?

A lot of trial and error. Learn to try to tell the difference between a comma ( , ) and a period ( . ) in DB Browser.

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

N/A

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

Yep, it's not easy to be familiar with the CTE function. I find that the temp tables are easier to use.

How were these changes tested?

Test ok

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

N/A

Checklist

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

Copy link
Copy Markdown

@niyazmnazari niyazmnazari left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Thank you for submitting assignment 2. Everything looks correct.
Point: 70/70

@yikai82 yikai82 changed the title Assignment two [approved] Assignment two Aug 20, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

4 participants