强悍HQL

select order.id, sum(price.amount), count(item)

from Order as order

? ? join order.lineItems as item

? ? join item.product as product,

? ? Catalog as catalog

? ? join catalog.prices as price

where order.paid = false

? ? and order.customer = :customer

? ? and price.product = product

? ? and catalog.effectiveDate < sysdate

? ? and catalog.effectiveDate?

>= all (

? ? ? ? select cat.effectiveDate

? ? ? ? from Catalog as cat

? ? ? ? where cat.effectiveDate < sysdate

? ? )

group by order

having sum(price.amount)?

> :minAmount

order by sum(price.amount) desc