Rishi,

You can do the same with 'select case...end'

SELECT

CASE

WHEN total >...