This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
The information you provided would be appropriate if you were asking us to help you write the SQL. HQL is based on objects, so for us to help you with this we need to see your objects and the hibernate relationships.