In an effort/bid to monitor the academic progress of students, Eduvos wants find out the information...

 

Transcribed Image Text:

In an effort/bid to monitor the academic progress of students, Eduvos wants find out the information of students who are on schedule (admitted from 1 January 2020 till date). This would enable the institute to make constant follow-up and adequately plan for the student's timely completion. a) Create a view named "ADMITTED_STUDENTS" that generate a list of students who have been admitted since 1 January 2021 order by date of admission (Admitteddate) till date in ascending order. b) Display the content of the view created in a) above. STUDENT NO P3D73M7F4 3D1JF84S5 9V6M76D3J N3M3N5D73 2JS763J5W SURNAME Mandiba Walus Gloria Sindiso Davis FIRST_NAME Renelwe Philips Lovelyn Lindiwe Dave D_O_B 21-Oct-00 14-Mar-06 04-Dec-02 03-Aug-07 25-Oct-07 ADMITTEDDATE 25-Mar-20 30-Nov-22 13-Dec-22 13-Mar-23 30-Mar-23 (4 Marks) (1 Marks) In an effort/bid to monitor the academic progress of students, Eduvos wants find out the information of students who are on schedule (admitted from 1 January 2020 till date). This would enable the institute to make constant follow-up and adequately plan for the student's timely completion. a) Create a view named "ADMITTED_STUDENTS" that generate a list of students who have been admitted since 1 January 2021 order by date of admission (Admitteddate) till date in ascending order. b) Display the content of the view created in a) above. STUDENT NO P3D73M7F4 3D1JF84S5 9V6M76D3J N3M3N5D73 2JS763J5W SURNAME Mandiba Walus Gloria Sindiso Davis FIRST_NAME Renelwe Philips Lovelyn Lindiwe Dave D_O_B 21-Oct-00 14-Mar-06 04-Dec-02 03-Aug-07 25-Oct-07 ADMITTEDDATE 25-Mar-20 30-Nov-22 13-Dec-22 13-Mar-23 30-Mar-23 (4 Marks) (1 Marks)

Answer rating: 100% (QA)

This question appears to be related to SQL Structured Query Language and concerns the creation and u... View the full answer