Home > mailing lists

Calculate the ratio - Mailing list pgsql-sql

From	Andreas Forø Tollefsen
Subject	Calculate the ratio
Date	August 15, 2011 12:21:41
Msg-id	CAGMz7DnkL2=VxpYqEsqTnMS=MTyDywgu_Z+b79X9ugqn5BgHpg@mail.gmail.com Whole thread Raw
Responses	Re: Calculate the ratio (msi77 <msi77@yandex.ru>) Re: Calculate the ratio ("David Johnston" <polobo@yahoo.com>)
List	pgsql-sql

Hi all,

This is probably quite simple. I want to calculate the ratio of each country (gwcode) which experiences a 1 in one column (cf).

Structure:

gid; gridyear; gwcode; area; cf

I want to select the SUM(area) WHERE cf = 1 into one column, and SUM(area) WHERE cf = 0 into another column and group by gridyear and gwcode.

Then i can see the ratio of the area of each country affected by cf.

Any suggestions?

Thanks.

From: David Harel
Date: 14 August 2011, 18:33:26
Subject: Re: pgadmin debugger

From: msi77
Date: 15 August 2011, 13:08:14
Subject: Re: Calculate the ratio