• Hugo Kornelis (4/7/2008)


    Hi all,

    In contrast to some other people in this discussion (and in many other QotD related discussions), I really don't care about points. Points are just a fun way to attract more audience to what should be a mix of fun and education. And the latter (the educational part) is what worries me when I see incorrect answers being marked as correct - and worries me even more when I see absolute bad practices being advertised as a correct answer, without even a disclaimer that this should never be done in a real system.

    I'm inclined to agree with all of that comment, inclusing the bit not quoted.

    I'd also thow in the comment that since there are a finited number of months in a year a predicate of the form month(join_date) in <list> must have a matching predicate of the form month(join_date) not in <list> so that if one could be right so could the other. So as well as the trivial mistype and the not-so-trivial assumptions about collation and locale it's probably also wrong to reject the third option, since people will surely interpret "list" as a placeholder in teh code for the appropriate list.

    Tom