JOINS - Filtering and Ordering

JOINs with filters

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 filtering to the JOIN result of students and courses with a WHERE clause.

Observe that we can add queries on multiple columns across the tables covered in the join.