Question is tricky. At a glance, it seems to have syntax error as there in no GROUP BY clause.

But, if we ignore it then 🙂