• u need to utilize the case statement in ur query.