does derive table use where clause fillters inside

Thank u sir , i knew that query can be forumualted in other way.

i just wanted to know how query gets processed in both conditions.

yours sincerely