我试图在一个case语句中使用Max（date）汇总当天的数字，并使用-interval汇总前一天的数字。

select  product,sum(
            case
            when date_started = max(date_started)
            then volume
            end )
      as "Current day's Volume",sum(
            case
            when date_started = max(date_started)
            then revenue
            end )
      as "Current day's Revenue",sum(
            case
            when date_started = (max(date_started) - interval '1 day' 
            then volume 
             end ) as "previous day's Volume",sum(
            case
            when date_started = (max(date_started) - interval '1 day' 
            then revenue 
             end ) as "Previous day's Revenue"
  from  lifetime_data
 group by 1

这是在PostgreSQL上。它不起作用。

示例数据

预期结果