On 21/08/07, Michael Glaesemann <[EMAIL PROTECTED]> 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 ahea
On Aug 18, 2007, at 0:35 , novice wrote:
What query do I write to generate the following?
week_no | count(record_id | count(observation_id) | sum(score_id)
where = '1'
2007, 30 | 2 | 8 | 6
2007, 29 | 1 | 2 | 1
Okay: let's take a look at what you're trying to get:
fi
Hi, We have the following three tables.
safety=> SELECT record_id, record_date FROM record;
record_id | record_date
---+
1 | 2007-07-23 11:30:37+10
2 | 2007-07-27 11:30:14+10
3 | 2007-07-17 13:15:03+10
(3 rows)
safety=> SELECT obser
