Exactly, it would have been fair game to ask why I used a window function instead of an aggregate function + subquery joined back onto the main result set. Or, to ask if I could rewrite the query another way which would be more efficient.
However, the interviewer didn't simply insist the query does not do what was asked (when it did indeed return the correct results).
Instead, the interviewer actually insisted it was an invalid query which would not run at all.
However, the interviewer didn't simply insist the query does not do what was asked (when it did indeed return the correct results).
Instead, the interviewer actually insisted it was an invalid query which would not run at all.