How would you write a query for this: Name of customers who made more then 10 purchases last quarter??
I think this is how to start:
SELECT name, MAX(qty_sold) AS sold
FROM fact f, products p, sales s, date d
WHERE ???????????????????????????????
AND d.date = 032002
[color]
I know this will return ALL max qty_sold...but I only want the top 10...what am I missing??
Thanks... I have not failed; I have merely found 100,000 different ways of not succeding...
I think this is how to start:
SELECT name, MAX(qty_sold) AS sold
FROM fact f, products p, sales s, date d
WHERE ???????????????????????????????
AND d.date = 032002
[color]
I know this will return ALL max qty_sold...but I only want the top 10...what am I missing??
Thanks... I have not failed; I have merely found 100,000 different ways of not succeding...