Hi GrassHopper,

Try this one for third scenario. I believe this will work for you..

case when (sum(total) over (partition by name1) >100) AND (MIN(total) over (partition by name1) < 25) AND...