Skip to content

Homework 1,2,3,4,5,6#1

Open
duggsun wants to merge 9 commits intomainfrom
homework
Open

Homework 1,2,3,4,5,6#1
duggsun wants to merge 9 commits intomainfrom
homework

Conversation

@duggsun
Copy link
Copy Markdown
Owner

@duggsun duggsun commented May 16, 2024

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

adding the logical data model homework at the end

What did you learn from the changes you have made?

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

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

How were these changes tested?

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

Checklist

  • I can confirm that my changes are working as intended

duggsun added 2 commits May 16, 2024 15:25
answered the sql query questions
@SidraBushra
Copy link
Copy Markdown

I cannot open your image for the homework1.

@duggsun
Copy link
Copy Markdown
Owner Author

duggsun commented May 17, 2024

Hi Sidra, it should be visible if you click on 'display the rich diff'
image

@duggsun
Copy link
Copy Markdown
Owner Author

duggsun commented May 17, 2024

also dropping the screenshot over here
image

@SidraBushra
Copy link
Copy Markdown

I can open it now, good choice of tables, accurate relationships.

@duggsun duggsun changed the title Update homework_1.md Homework 1,2 May 18, 2024
@duggsun duggsun changed the title Homework 1,2 Homework 1,2,3 May 18, 2024
@SidraBushra
Copy link
Copy Markdown

For HW2, you forget to mention order by in the end of query for the Where query task, others correct.

@SidraBushra
Copy link
Copy Markdown

For HW3, Left join is more accurate choice of join for aggregate query, and for date query task group by month and year as well. Others correct.

@duggsun duggsun changed the title Homework 1,2,3 Homework 1,2,3,4 May 24, 2024
@duggsun duggsun changed the title Homework 1,2,3,4 Homework 1,2,3,4,5 May 24, 2024
@SidraBushra
Copy link
Copy Markdown

HW 4, 5 Marked, Passed.

@duggsun duggsun changed the title Homework 1,2,3,4,5 Homework 1,2,3,4,5,6 May 26, 2024
@SidraBushra
Copy link
Copy Markdown

HW6 marked, Passed.

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.

2 participants