Return Y or N in a query using COALESCE

SELECT A.BUSINESS_UNIT, A.REQ_ID,
COALESCE((SELECT ‘Y’ FROM PSROLEUSER_VW B WHERE A.REQUESTOR_ID=B.OPRID AND ROLENAME=’REQUESTER’), ‘N’) YES_NO
FROM PS_REQ_HDR A