78. Practice - MAX with Filter

Exercise: Maximum in Python

Find highest marks among Python students.

Solution

1SELECT MAX(marks) FROM students
2WHERE course = 'Python';