Skip to content

homework1 submmison#1

Open
pamwang86 wants to merge 7 commits intomainfrom
homework
Open

homework1 submmison#1
pamwang86 wants to merge 7 commits intomainfrom
homework

Conversation

@pamwang86
Copy link
Copy Markdown
Owner

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

I have created a logic data model between two tables.

What did you learn from the changes you have made?

I learned how to load database, how to read tables.

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?

No

How were these changes tested?

N/A

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

Checklist

  • I can confirm that my changes are working as intended

@SidraBushra
Copy link
Copy Markdown

Good Work!

@SidraBushra
Copy link
Copy Markdown

For HW2, For Question2, your Where Query in which you have to use AND is false.

@pamwang86
Copy link
Copy Markdown
Owner Author

For HW2, For Question2, your Where Query in which you have to use AND is false.

Correction:
SELECT product_id,vendor_id,market_date,customer_id,quantity,cost_to_customer_per_qty,transaction_time,quantity * cost_to_customer_per_qty as 'price'
FROM customer_purchases
WHERE vendor_id > 8 AND vendor_id <= 10

@SidraBushra
Copy link
Copy Markdown

HW3, good. Pass

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