Recent content by DanielD

Nobody in class could do it, we're told to ask eachother so....

I just wanted to know if there was a quicker way to do the adding up, that's all

Nah it wasn't to find that bit out, it was to say what tables would be used to find it. I could've done that bit myself, I'd have add up all of the large groups together. to see what was most common

All I could see was them all individually, not how to group them together. We were never taught this in lesson

Its for a college assignment, this is the database we were given. I've tried to do query for the quantity of products sold but its not grouping them by name (there is sometime multiple orders from different customers)

How would I go about finding the most popular and must unpopular product in this database? Thank you :)