On Tue, Jun 16, 2009 at 2:52 PM, Hall, Crystal M CTR DISA
JITC<Crystal.Hall.ctr@disa.mil> wrote:
> Maybe I am way of base here, but I see a reference to region in this
> query. However, I think count(cm.id) is correct because some would have
> a count of 0. Count(*) would produce counts when there are no
> complaints. (If I understand the logic, again, I am VERY new to this)
Here is a very good website to visit to get practice with SQL using PostgreSQL.
http://www.sqlzoo.net/select_group_by
If you look up at the upper right corner of the web-page, you can
select PostgreSQL are your RDBMS (other flavors are available also).
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug