Subqueries


SELECT name, grade, marks
FROM   students
WHERE  marks BETWEEN (
                        SELECT MIN(marks)
                        FROM   students
                        WHERE  grade = 7
                     )
                     AND
                     (
                        SELECT MAX(marks)
                        FROM   students
                        WHERE  grade = 6
                     )
