How do I find the most popular products (1 Viewer)

DanielD · Nov 30, 2017

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

Thank you

Uncle Gizmo · Nov 30, 2017

Have you sold any?

Sent from my SM-G925F using Tapatalk

DanielD · Nov 30, 2017

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 · Nov 30, 2017

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

isladogs · Nov 30, 2017

Have you sold any?

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

Query used:

Code:

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 · Nov 30, 2017

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

isladogs · Nov 30, 2017

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

DanielD · Nov 30, 2017

ridders said:
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 · Nov 30, 2017

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 · Nov 30, 2017

ridders said:
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 · Nov 30, 2017

Like getting someone else to do it for you?

DanielD · Nov 30, 2017

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

isladogs · Nov 30, 2017

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

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

How do I find the most popular products (1 Viewer)

DanielD

New member

Attachments

Uncle Gizmo

Nifty Access Guy

DanielD

New member

Minty

AWF VIP

isladogs

MVP / VIP

DanielD

New member

isladogs

MVP / VIP

DanielD

New member

isladogs

MVP / VIP

DanielD

New member

isladogs

MVP / VIP

DanielD

New member

isladogs

MVP / VIP

Similar threads

Users who are viewing this thread