>  one solution would be to drop that field in the select, which is not what we want

In the contrary, this is what we want. This is exactly the purpose of `GROUP BY`: to aggregate data. If you group by `author,title` instead of `author`, you'll return the whole table, which is the same as not using `GROUP BY` at all.