返回依赖于另一列的值的值

I thought this would be pretty easy but for some reason, I can't wrap my head around it. Maybe I am tired. Anyway, I want to return a policy value that has a status code of 1 and 4. I have a simple query:I thought this would be pretty easy but for som