SQL 92 answer.
Re: List from particular customers with minum orders?
[sql]
SELECT w.name, w.year, Sum(o.qty)
FROM customers c, orders o, wines w
WHERE c.nb=o.nb AND o.nv=w.nv
AND c.town='Paris'
GROUP BY w.name, w.year
HAVING Sum(o.qty) > 100
ORDER BY w.name, w.year
[/sql]
|