How to show one latest post per author on Wordpress front page

If you have have a self-hosted blog with multiple users, and you want to display one latest post per each author on the front page, you can accomplish this with a very powerful “posts_where” filter provided by Wordpress. See the example below.