view

 CREATE OR REPLACE FORCE VIEW "WORKSHOP2"."APP_STUDENT" ("APPLICATION_ID", "APPLICATION_STATUS", "APPLICATION_TYPEOFSTICKER", "VEHICLE_ID", "VEHICLE_PLATENO", "STUDENT_ID", "STUDENT_NAME", "APPLICATION_DATE", "APPLICATION_ROFR", "APPLICATION_SESSION", "APPLICATION_LETTER", "STUDENT_EMAIL") AS
  SELECT application.application_id,application.application_status, application.application_typeofsticker,vehicle.vehicle_id, vehicle.vehicle_plateno
, student.student_id, student.student_name,application.application_date,application.application_rofr,application.application_session,application.application_letter,student.student_email
from application natural join vehicle natural join student where
applicant_vehicleid= vehicle_id and applicantstudent_id= student_id;