Example database view

student_view.sql

DROP VIEW IF EXIXTS student_views;
CREATE VIEW student_views AS
  SELECT
    students.id AS id,
    students.name AS name,
    teachers.name AS teacher_name,
    schools.name AS school_name,
    countries.name AS country_name
  FROM students
  LEFT JOIN teachers ON teachers.id = students.teacher_id
  LEFT JOIN schools ON schools.id = students.school_id
  LEFT JOIN countries ON countries.id = students.country_id