0 - 1 of 1 tags for when

I have a requirement in that i have to use two qualify in the same query based on the value returned(this value is also returned by a qualify statement).

 

Ex :

 Ex1

 

NAME1

NAME2

AGE

RANK

A

B

1

1

A

C