Q: 9
This clause is used to group the output of a stats command by a specific name.
Options
Discussion
Option B, D is usually the trap here, but "as" renames fields in stats output.
B tbh. D is tempting since it says "group", but in stats,
as is the clause that names the field, not groups it. Seen this trick on practice tests before, so B makes more sense.Probably B, D is for grouping but this asks about the renaming clause.
Yeah, D looks tempting since 'by' definitely groups results in stats, but the question is about the clause used to assign a specific name to the output field. That's 'as' (B). D is a classic trap for anyone scanning too fast. Pretty sure I've seen similar phrasing on practice tests, so going with B unless I'm missing a subtle wording trick.
B is right here. The
as clause in stats is used to rename the resulting field, while by would group results. I saw a similar question in practice sets. Correct me if I'm off.Not D, B. Had something like this on my exam, pretty sure it's B for naming fields in stats output.
Be respectful. No spam.
