with us as (select operation, usagetype, sum(usagevalue)/1024/1024/1024 as usage_value from s3usage where resource='foobar' group by operation, usagetype ) select * from us where usage_value > 1;
    operation    |       usagetype        |      usage_value
-----------------+------------------------+-----------------------
 GetObject       | DataTransfer-Out-Bytes | 1049.5139386812224961
 StandardStorage | TimedStorage-ByteHrs   | 3332.3039097860455518
 PutObject       | DataTransfer-In-Bytes  |    9.6716320738196373
(3 rows)