Sound for critical alarms

I'm sure there is a better and more efficient way, but this is how I did it:

Very curious about performance impacts of this query now, would appreciate any insight.