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.)
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.)
To retrieve only those books with between 500 and 750 total pages using JPQL, the correct clause is WHERE pub.pages BETWEEN 500 AND 750. This clause accurately filters the results to the specified range. The other options either contain incorrect logical operators or use aggregate functions incorrectly, which would not achieve the desired result.
A and C
Answer A, C
A and C are the correct answers
the correct answer is C, and ether B or D should say WHERE pub.pages >= 500 AND pub.pages <= 750 which would also be correct