[collyw]

I find the SQL version a lot easier to read. I assume the other way would be less effort to write. (Though should you not have a GROUP BY in there for the count?)

In contrast to most languages, I do find SQL is generally easier to understand when reading it, rather than writing it.