日常任务-07-技术-5.师姐又教我如何用一条clickhouse的sql--case when实现一个接口

//获取夜间交易金额及夜间交易金额与全天交易金额的占比
sjh:手机号
jysj:交易时间
jyje:交易金额

SELECT  t.sjh,
(case when 
((toHour(cast(t.jysj as datetime)) >= 23 and toHour(cast(t.jysj as datetime)) <= 24)
or (toHour(cast(t.jysj as datetime)) >= 00 and toHour(cast(t.jysj as datetime)) <= 05))
then sum(t.jyje)   else 0 end) as sumYjJyje,
(case when 
(t.jysj!=null)
then sum(t.jyje)   else 0 end) as sumJyje 
  from hndx.person_bank_info t  where  t.sjh = '13787201324'  GROUP by t.sjh,t.jysj;