Re: Join query help

On 21/08/07, Michael Glaesemann <grzm(at)seespotcode(dot)net> wrote:

> Now here's where I started having trouble. I can't figure out how to
> get 2 observations for week 29 (record_id 1 & 3) and 8 for week 30
> (record_id 2). Assuming the data is wrong (which is admittedly a poor
> assumption), I moved ahead.

> > week_no | count(record_id | count(observation_id) | sum(score_id)
> > where = '1'
> > 2007, 30 | 2 | 8 | 6
> > 2007, 29 | 1 | 2 | 1

For week 29, there were 1 SAFE observation out of the 2 observations and
for week 30, there were 6 SAFE obseravations out of the 8
observations. Hope this helps.

Thanks!