Get different sums from the same table in one query - Mailing list pgsql-sql

From Dani Castaños
Subject Get different sums from the same table in one query
Date
Msg-id 470A0B20.40203@gmail.com
Whole thread Raw
Responses Re: Get different sums from the same table in one query
Re: Get different sums from the same table in one query
List pgsql-sql
Hi all!

I want to put this three queries in only one... Take a look that the 
only thing that changes is the message_type_id. Any suggestions??
        SELECT TO_CHAR( statistics_date, 'DD/MM/YYYY') AS date_in, 
sum(total_num_messages)        FROM statistics_daily        WHERE message_type_id IN (4,5)        AND statistics_date =
CURRENT_DATE       AND telecom_operator_id <> 0        AND telephone_number IN ( $numbers )        GROUP BY date_in
 
        SELECT TO_CHAR( statistics_date, 'DD/MM/YYYY') AS date_in, 
sum(total_num_messages)        FROM statistics_daily        WHERE message_type_id IN (6)        AND statistics_date =
CURRENT_DATE       AND telecom_operator_id <> 0        AND telephone_number IN ( $numbers )        GROUP BY date_in
 
        SELECT TO_CHAR( statistics_date, 'DD/MM/YYYY') AS date_in, 
sum(total_num_messages)        FROM statistics_daily        WHERE message_type_id IN (21)        AND statistics_date =
CURRENT_DATE       AND telecom_operator_id <> 0        AND telephone_number IN ( $numbers )        GROUP BY date_in
 



Thank you in advance!


pgsql-sql by date:

Previous
From: Rodrigo De León
Date:
Subject: Re: SQL query question
Next
From: "A. Kretschmer"
Date:
Subject: Re: Get different sums from the same table in one query