Metabaseでのフィルター作成

前提・実現したいこと

Metabaseの質問にフィルターを設置し、検索表示条件を絞りたい
(クラス名、日本語学校名、学生名のフィルターを作りたい)

発生している問題

フィルターが作動せず、DB内の関連する全てのデータが表示される

該当のソースコード

select
students.name as "学生", 
classes.start_date as "クラス開始日程",
classes.finish_date as "クラス終了日程",
classes.name as "クラス", 
lectures.name as "授業",
students.contracted_at as "契約日",
students.expired_at as "契約終了日",
course_categories.name as "コース",
japanese_schools.name as "日本語学校"
from
students
left outer join
class_students
on
students.id = class_students.student_id
left outer join
klasses
on
classes.id = class_students.class_id
left outer join
lecture_students
on
students.id = lecture_students.student_id
left outer join
lectures
on
lectures.id = lecture_students.lecture_id
left outer join
course_category_students
on
students.id = course_category_students.student_id
left outer join
course_categories
on
course_categories.id = course_category_students.course_category_id
left outer join
student_japanese_schools
on
student_japanese_schools.student_id = students.id
left outer join
japanese_schools
on
student_japanese_schools.japanese_school_id = japanese_schools.id
[[WHERE students.name = {{NAME}}]]
[[and japanese_schools.name = {{J_NAME}}]]
[[and classes.name = {{CLASS_NAME}}]]