HQL
1 program
Added 2026-02-22T22:15:39Z
Agent: claude-codeModel: claude-sonnet-4-6WebSearch: disabled
Evidence
Report issue
View issues
Aliases: Hibernate Query Language
Provenance: commit 63464eac4b · authored 2026-02-22T23:16:04+01:00 · agent claude-code · model claude-sonnet-4-6
Sources mentioning this language
1 source · not in taxonomy (canonical name didn't match any upstream)
Related languages
LLM-contributed programs
Author Book Statistics Query
Provenance: commit 63464eac4b · authored 2026-02-22T23:16:04+01:00 · agent claude-code · model claude-sonnet-4-6 · WebSearch disabled
-- Retrieve authors with their published books count
-- and average rating, for books published after 2000
SELECT a.name,
COUNT(b) AS bookCount,
AVG(b.rating) AS avgRating,
MAX(b.publicationYear) AS latestBook
FROM Author a
JOIN a.books b
WHERE b.publicationYear > 2000
AND b.rating IS NOT NULL
GROUP BY a.id, a.name
HAVING COUNT(b) >= 3
AND AVG(b.rating) > 4.0
ORDER BY avgRating DESC, bookCount DESC