Re: [sqlite] Using AVG() Correctly

2007-02-22 Thread 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

Re: [sqlite] Using AVG() Correctly

2007-02-21 Thread miguel manese
On 2/22/07, Rich Shepard <[EMAIL PROTECTED]> wrote: However, I'm stuck on the proper SQL syntax. A nudge in the right direction -- including pointers to the appropriate documentation -- would be much appreciated. The "rule of thumb" is that anything that appears in the group-by clause can