Re: [sqlite] Using AVG() Correctly

[Rich Shepard]

On Thu, 22 Feb 2007, miguel manese wrote:

Best example using your particular case is Igor's answer:

select cat, pos, avg(col1), avg(col2), ...
from voting
group by cat, pos;

  Thank you, Miguel.

Rich

--
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------