Open
Conversation
monzchan
approved these changes
Nov 19, 2025
|
|
||
| FROM customer_purchases | ||
|
|
||
| WHERE product_id = 4 AND product_id = 9; |
There was a problem hiding this comment.
product_id cannot be 4 and 9 at the same time. consider BETWEEN
Owner
Author
There was a problem hiding this comment.
Hi Moniz,
The problem statement specifically states customer purchases of product ids 4 and 9 (please see the problem statement quoted below). How can it be between 4 and 9?
"1. Write a query that returns all customer purchases of product IDs 4 and 9"
| FROM vendor, vendor_booth_assignments | ||
|
|
||
| WHERE vendor.vendor_id = vendor_booth_assignments.vendor_id | ||
| GROUP by vendor.vendor_id, vendor_booth_assignments.booth_number; |
There was a problem hiding this comment.
Grouping by booth_number is unnecessary and will produce multiple rows per vendor.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
2 participants
Add this suggestion to a batch that can be applied as a single commit.This suggestion is invalid because no changes were made to the code.Suggestions cannot be applied while the pull request is closed.Suggestions cannot be applied while viewing a subset of changes.Only one suggestion per line can be applied in a batch.Add this suggestion to a batch that can be applied as a single commit.Applying suggestions on deleted lines is not supported.You must change the existing code in this line in order to create a valid suggestion.Outdated suggestions cannot be applied.This suggestion has been applied or marked resolved.Suggestions cannot be applied from pending reviews.Suggestions cannot be applied on multi-line comments.Suggestions cannot be applied while the pull request is queued to merge.Suggestion cannot be applied right now. Please check back later.
UofT-DSI | sql - Assignment 1
What changes are you trying to make? (e.g. Adding or removing code, refactoring existing code, adding reports)
Checking in the solutions for SQL queries to Assignment 1
What did you learn from the changes you have made?
I learnt how to write SQL queries using SELECT, WHERE, JOIN, HAVING etc.
Was there another approach you were thinking about making? If so, what approach(es) were you thinking of?
No other approaches
Were there any challenges? If so, what issue(s) did you face? How did you overcome it?
I faced challenges in joining and combining others SQL commands with queries. I overcame the challenges by re-visiting the recorded training sessions and third-party videos on YouTube.
How were these changes tested?
By executing the SQL commands in DB Browser for SQLite
A reference to a related issue in your repository (if applicable)
N/A
Checklist