• Nice one, thank you for posting.

    (By seeing the output table.. it was sure that date is today's and from the options... I selected 4 quickly and then... realized the format of the date in the output is not same as getdate()'s, so I confirmed "okay it needs convert..." and option was 3... okay... finally I got the answer right; but "damn!! it showed the answer as wrong and was wondering... and again realized.. I did not switch the answer to 3... " Note to self: mental analysis is good, but online submission needs accurate practical selection.)

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.