Re: Query to get the min of the total

----- Original Message -----

From: Marta Pérez Romero

To: Oliveiros d'Azevedo Cristina

Cc: pgsql-novice@postgresql.org

Sent: Friday, May 04, 2012 12:19 PM

Subject: Re: [NOVICE] Query to get the min of the total

The below works!!! I am investigating if it covers everything, but looks good!

Thanks a mill!!!!

On 4 May 2012 12:12, Oliveiros d'Azevedo Cristina <oliveiros.cristina@marktest.pt> wrote:

SELECT *

FROM

(

SELECT petname,SUM(quantity) as total

FROM pets a

NATURAL JOIN sales b

GROUP BY petname

) x

NATURAL JOIN

(SELECT MIN(total) as total

FROM

(

SELECT petname,SUM(quantity) as total

FROM pets a

NATURAL JOIN sales b

GROUP BY petname

)y

)z