How to improve multiple case when query performance?
this condition prevents database server from using index seek:

cast(s.event_time as date) between '2020-03-01'


first you need to change it to:

s.event_time &gt;= '2020-03-01' AND s.event_time &lt; '2020-04-01'