Join query help
От | novice |
---|---|
Тема | Join query help |
Дата | |
Msg-id | ddcb1c340708172235w3b07b912od246e76fa9109646@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Join query help
|
Список | pgsql-sql |
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-1713:15:03+10 (3 rows) safety=> SELECT observation_id, record_id, score_id FROM observation;observation_id | record_id | score_id ----------------+-----------+---------- 3240 | 1 | 1 3239 | 1 | 1 3238 | 1 | 2 3237 | 1 | 1 2872 | 2 | 1 2869 | 2 | 2 2870 | 2 | 1 2871 | 2 | 1 3218 | 3 | 2 3217 | 3 | 1 (10 rows) safety=> SELECT * FROM SCORE;score_id | score_description ----------+------------------- 0 | NA 1 | SAFE 2 | AT RISK (3 rows) 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
В списке pgsql-sql по дате отправления: