一个纠结的sql分组查询语句

oracle的写法, mysql也有case when的表达式

Select t.Dormitory,

   Sum(Case
         When t.Time >= Trunc(Sysdate) - 2 And t.Time < Trunc(Sysdate) - 1 Then
          t.Electric
         Else
          0
       End) day2ago,
   Sum(Case
         When t.Time >= Trunc(Sysdate) - 1 And t.Time < Trunc(Sysdate) - 0 Then
          t.Electric
         Else
          0
       End) day1ago

From Dormitoryelectric t
Group By t.Dormitory