Conversation
…nto assignment-two i could not push earlier. Hence trying a pul and then push
efantinatti
left a comment
There was a problem hiding this comment.
Dear Ann Paul
Session 1:
1 - OK.
Session 2:
2 - Partial.
--Windowed Functions - Q2: Query os not fully correct. Observe the distinct clause. Check it out.
--Windowed Functions - Q3: Query is not fully correct. Consider using partition.
Session 3:
3 - Partial.
-- CROSS JOIN - Q1: Your query is not displaying the right results. Please consider making it simpler cross-joining with customers and not customer_purchases. Note that you don't need to count customers. The vendor_product_combinations seems correct but not the others. Please check it out.
-- UPDATE - Q1: Query seems Ok but COALLESCE clause is not working and it is returning NULL values. Please check it out.
Final:
4 - Check the aforementioned points prior to merging your feature branch 'assignment-two' to 'main'.
Mark: 60 points.
What changes are you trying to make? (e.g. Adding or removing code, refactoring existing code, adding reports)
add changes by modifying the md file with ERD and sql file with new queries
What did you learn from the changes you have made?
Querying with advanced topics
Was there another approach you were thinking about making? If so, what approach(es) were you thinking of?
NA
Were there any challenges? If so, what issue(s) did you face? How did you overcome it?
YES. the last question was a bit challenging
How were these changes tested?
the testing was done in sqlite browser
A reference to a related issue in your repository (if applicable)
NA
Checklist