// OF FIRST_NAME, LAST_NAME
QAuthor author = QAuthor.author;
QBook book = QBook.book;
MySQLQuery query = new MySQLQuery(null);
query.from(author)
.join(book).on(author.id.eq(book.authorId))
.where(book.language.eq("DE"), book.published.eq(new Date()))
.groupBy(author.firstName, author.lastName)
.having(Wildcard.count.gt(5))
.orderBy(author.lastName.asc())