Let's say we want to display names and marks of students who are enrolled in either JavaScript course or Python course and have marks between 15 and 85, along with the name of the course.
In this case, we can add filter to the JOIN result of students and courses with a WHERE clause.
Note that we can add queries on multiple columns across the tables covered in the join.