I am wanting to write a query that will evaluate the time difference between the time an alarm was presented to the time a ticket was created, (I have that part). What I am need is to to evaluate the duration to see if it went over 5 minutes, if it did then "Fail", else "Pass".
The issue is that I wanting to evaluate it in a single case statement. The reason is because I have other evalautions to write and don't want to nest select statments yet.
Here is what I have so far.