• i think this the group by was left by mistake ...

    if we over look that group by then the option 3 is the right answer and thats pretty much fineee...

    Mithun