Consider the following SO post: Can I treat a subquery with one row and one column as a scalar?. Currently, I see my deleted answer to that post sometimes sorting above non-deleted answers (varies on each refresh):
I suspect that this isn't supposed to happen, given that Please sort deleted answers to the bottom and Deleted answers should get sorted at the very bottom of the answer list were marked status-completed back in the time of the dinosaurs.
In case it matters, I have less than 10k rep on SO at this time.