Good question, although not that hard (for 2 points).
It is very interesting. However, am still not clear on [flag ='y' ]. Can someone tell me what is this flag. I didnt get any content in BOL.
The flag isn't actually there. Since it is contained in brackets, it is just an alias name for the table.