Question 56:
Given the JPQL code fragment: Select pub.title, pub.author, pub.pages FROM Publisher pub Which two clauses do you add to this JPQL query to retrieve only those books with between 500 and 750 total pages? (Choose two.)
Answer options:
A. WHERE MIN(pages) >= 500 AND MAX(pages) <= 750 B. WHERE pub.pages <= 500 OR pub.pages >= 750 C. WHERE pub.pages BETWEEN 500 AND 750 D. WHERE pub.pages <= 500 AND pub.pages >=750