I think the question is good and the possible answers were fine. To me, the first 2 possible answers showed what the author was trying to get across. I agree that the query is bad and as GSquared said it shows that just because a query runs doesn't make it correct nor does it make it good.