help needed

[Lebowski]

Problem

i have records like these:

name quantity quality
A 5 2.5
B 4 1
B 3 2
C 1 1.5
.... ... ...

I want to create a new table with averague quality value for each
records that have the same "name", in this example:

name quality
A 2.5
B 1.428
C 1.5
... ...

anybody can help?

[CDMAPoster]

CD********@Fort uneJames.com wrote:

Thelma Lubkin wrote:

Fred Zuckerman <Zu********@sbc global.net> wrote:
: "Lebowski" <bd*******@gmai l.com> wrote in message
: news:11******** **************@ g10g2000cwb.goo glegroups.com.. .
: 1st Query = qryProduct1:
: ------------------------------
: SELECT Product, Sum([Quantity]*[Quality]) AS SumOfQQ, Sum(Quantity) AS
: SumOfQuantity FROM Table1 GROUP BY Product;

: 2nd Query = qryProduct2:
: ------------------------------------
: SELECT Product, [SumOfQQ]/[SumOfQuantity] AS AvgQuality FROM qryProduct1;

How would you do this completely in SQL, without any reference to
queries?
--thelma

: Fred Zuckerman

Maybe something like:

SELECT theName, Sum(Quality * Quantity) / Sum(Quantity) AS AvgQuality
FROM tblNames WHERE Quantity IS NOT NULL GROUP BY theName;

Perhaps the extra query is used to allow checking for the case of a
zero denominator. You don't want that to happen.

James A. Fortune
CD********@Fort uneJames.com

How about:

SELECT theName, IIf(Sum(Quantit y) <> 0, Sum(Quality * Quantity) /
Sum(Quantity), 'Div by 0 problem') AS AvgQuality FROM tblNames WHERE
Quantity IS NOT NULL GROUP BY theName;

James A. Fortune
CD********@Fort uneJames.com

and we think SOAP is a really great way of building both infrastructure
and application protocols.

SOAP enables rich extensibility & security.

Metadata or SOAP.

Under Windows Communications Foundation (WCF), you can code C# directly
into XSLT.

-- Doug Purdy, PDC 05, COM326: Web Services for XML Programmers