Please help I need help creating this.

• You should create one View per table and save the View script for each.
• You should also create one view that shows column information from two related tables using a join.
• You should create two (2) queries using data from two or more tables; each query to contain calculated fields. At least one of the queries must use GROUP BY and HAVING along with calculated fields. All calculated fields must have Aliases for ease of readability by the users. You will also create at least one procedure.

course 8 course_id title duration cost instructor 8 instructor_id instructor_name salary commission mentor_id date_hired subject_id student 8 student_id student_fname student_lname tel_no fax_no gender date_of_birth student_desc preferred_language passport_program company_id attendance 8 offering_id student_id evaluation amount_paid O- oc offering offering_id course_id instructor_id site_id start_date max_no_students course 8 course_id title duration cost instructor 8 instructor_id instructor_name salary commission mentor_id date_hired subject_id student 8 student_id student_fname student_lname tel_no fax_no gender date_of_birth student_desc preferred_language passport_program company_id attendance 8 offering_id student_id evaluation amount_paid O- oc offering offering_id course_id instructor_id site_id start_date max_no_students