Check this out
select
reg_time,
resolution_deadline,
resolution_elapsetime,
resolution_time,
Ticket_id,
datediff(minute,reg_time,resolution_time) as [minutes to solve],
datediff(minute,reg_time,resolution_deadline) as [max minutes allowed],
(cast(datediff(minute,reg_time,resolution_time) as float) /cast( datediff(minute,reg_time,resolution_deadline) as float)) *100 as [percent to solve],
case when (cast(datediff(minute,reg_time,resolution_time) as float) /cast( datediff(minute,reg_time,resolution_deadline) as float)) > 75 then 'Yes' else 'No' end as [75%],
case when (cast(datediff(minute,reg_time,resolution_time) as float) /cast( datediff(minute,reg_time,resolution_deadline) as float)) > 100 then 'Yes' else 'No' end as [100%]
I included the steps in the select so you can see what's going on.
Hope that helps ^_^
Andy