This query gives the following result: