I am working on a requirement that requires me to find whether an employee applied to the same job name  more than once. If they apply to job name A with a job number 123  and the hiring manager decides they are more qualified for say the same job name but say a different job number , then  I need to assign a flag of N otherwise assign a Y. I am trying to use case statements but not sure if that's the right approach or even how to implement it. any suggestions?