11

@Query("SELECT CONCAT(a.firstName, ' ', a.lastName, ' - ', SUM (b.copies)) FROM Book AS b " +
            "INNER JOIN b.author AS a GROUP BY a.id ORDER BY SUM (b.copies) DESC")
    Set<String> findTotalNumberOfBookCopiesByAuthor();