Subqueries
47.3
Exercise

Subqueries - 2

Write a query to display name, grade and marks of all students who have scored marks which lie between the lowest marks scored by a student in grade 7 and the highest marks scored by a student in grade 6. Let the headers of result columns be name, grade and marks respectively.

HINT: Subqueries can also serve as the two sides of a BETWEEN operator in a WHERE filter.