Creat.e a view student_enrollment_details to see enrollment details of students for the Fall 2021 Term. writ and test your SELECT query before using it to creat the view. Filter the data to see details of classes which are not Online. (Hint: Use meeting_days column to filter out the courses which are not Online) Note: Once you've createed the view you can easily run it with the following code: 

SELECT * FROM student_enrollment_details;

  

Transcribed Image Text:

name Abby Garcia Aiko Ito Albrecht Ambrogetti Antonie Avramovsky Ariella Basindale Carley Argue Carolynn Matityahu Derrick Bell Dix Harse Don Lee term Fall 2021 Fall 2021 Fall 2021 Fall 2021 Fall 2021 Fall 2021 Fall 2021 Dustin Nguyen Edward Brooke Ellene Van Baaren Fernando Gaviria Francis Slaughter st on Fall 2021 Fall 2021 Fall 2021 isqa b no_of_courses_enrolled ggl 2 Fall 2021 Fall 2021 Fall 2021 2 4 2 2 4 3 3 2 3 credits taken courses_with_prerequisites 6 10 this assignm 6 6 6 10 10 10 6 6 10 9 9 6 9 0 3 0 0 0 3 3 3 0 0 3 3 3 0 3 name Abby Garcia Aiko Ito Albrecht Ambrogetti Antonie Avramovsky Ariella Basindale Carley Argue Carolynn Matityahu Derrick Bell Dix Harse Don Lee term Fall 2021 Fall 2021 Fall 2021 Fall 2021 Fall 2021 Fall 2021 Fall 2021 Dustin Nguyen Edward Brooke Ellene Van Baaren Fernando Gaviria Francis Slaughter st on Fall 2021 Fall 2021 Fall 2021 isqa b no_of_courses_enrolled ggl 2 Fall 2021 Fall 2021 Fall 2021 2 4 2 2 4 3 3 2 3 credits taken courses_with_prerequisites 6 10 this assignm 6 6 6 10 10 10 6 6 10 9 9 6 9 0 3 0 0 0 3 3 3 0 0 3 3 3 0 3

Answer rating: 100% (QA)

CREATE VIEW studentenrollmentdetails AS SELECT enrollmentid studentid courseid coursename instructor... View the full answer