How do I find the most popular products

[DanielD]

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

Thank you

 

[Uncle Gizmo]

Have you sold any?

Sent from my SM-G925F using Tapatalk

 

[DanielD]

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)

 

[Minty]

As it's an assignment - you won't learn if you don't try, show show us what you have tried.

 

[isladogs]

Have you sold any?

Most popular: Camembert Pierrot - 1577 ordered
Least popular: Mishi Kobe Niku - 95 ordered

Query used:

SELECT Products.ProductID, Products.ProductName, Sum([Order Details].Quantity) AS TotalOrdered
FROM Products INNER JOIN [Order Details] ON Products.ProductID = [Order Details].ProductID
GROUP BY Products.ProductID, Products.ProductName
ORDER BY Sum([Order Details].Quantity) DESC;

EDIT:
Whilst I was answering this, you added it was a college assignment.
If I'd known I would have given a hint & not the answer.
Too late now
In future, PLEASE state that in your first post

 

[DanielD]

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

 

[isladogs]

So that was your homework ...to find out!

 

[DanielD]

So that was your homework ...to find out!

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

 

[isladogs]

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

If you could have done it yourself, why didn't you?

 

[DanielD]

If you could have done it yourself, why didn't you?

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

 

[isladogs]

Like getting someone else to do it for you?

 

[DanielD]

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

 

[isladogs]

A word of advice - please read this post....

https://www.access-programmers.co.uk/forums/showthread.php?t=296747