Master Hibernate and JPA with Spring Boot in 100 Steps - Step 51 - JPQL - Courses with 2 Students and order by

The video tutorial covers JPQL queries, focusing on finding courses with a specific number of students and ordering courses by the number of students. It demonstrates how to execute these queries, handle exceptions, and interpret results. The tutorial highlights the ease of using JPQL for complex queries, as Hibernate generates the necessary SQL. The video concludes with an example of ordering courses in both ascending and descending order based on student count.

What is the correct way to find courses with at least two students using JPQL?

• Use 'count(C.students) >= 2'

• Use 'size(C.students) >= 2'

• Use 'C.students.size >= 2'

• Use 'C.students >= 2'

Why did the initial JPQL query to find courses with more than two students fail?

• The query was not executed properly.

• The query was missing a join statement.

• The query syntax was incorrect.

• The query did not use the size function for students.

Which course was found to have more than two students?

• Spring Boot in 100 Steps

• Hibernate in 100 Steps

• JPA in 50 Steps

• Spring in 50 Steps

How can you order courses by the number of students in descending order using JPQL?

• Use 'order by C.students.size desc'

• Use 'order by count(C.students) desc'

• Use 'order by size(C.students) desc'

• Use 'order by C.students desc'

What is the default order when using 'order by' in JPQL?

• Alphabetical

• Ascending

• Random

• Descending