Answer all of the questions with a thumb up! ( Using SQL Oracle to write)

Hi there, pls refer to this link to get more info that you need (https://www.chegg.com/homework-help/questions-and-answers/answer-questions-thumb-using-sql-oracle-write--tks-q68326249?trackid=gVHoUgMM).

233% Zoom View Add Page Insert Table Chart Text Shape Media Comment Collaborate Format Document 7. Create a view (vwEmployeeManager) to display all information of all employees and the Employee Number, First Name and the Last Name of their managers if there is any manager that the employee reports to. Include all employees, including those who do not report to anyone. Sort based on Manager Employee Number. Write a statement to view the results of the view just created. 1 2 4 5 G 2 31 EMPLOYEEPEES LASTIE PIASTRAME TEXTENSIONEVAL CPPICCOLE RECETSTO CETITLE 1056 Patterson Mary X4611 mpatterso@classicmodelca... 1 1002 VP Sales 1076 Firrelli Jeff x9273 rel classicmodelca... 1 1002 VP Mark... 1102 Bondur Gerard x5408 gbondur@classicmodelcars... 4 1056 Sale Ma... 1088 Patterson William x4871 wpatterson@classicmodelc... 6 1056 Sales M... 1143 Bow Anthony x5428 abow@classicmodelcars.com 1 1056 Sales M... 1621 Nishi Mami x101 mnishi@classicmodelcars.com 5 1056 Sales Rep 1611 Fixter Andy x101 afixter@classicmodelcars... 6 1088 Sales Rep 1612 Marsh Peter x102 marsh@classicmodelcars.com 1088 Sales Rep 1619 King Tom x103 tking@classicmodelcars.com 6 1088 Sales Rep 1370 Hernandez Gerard x2028 ghernande@classicmodelca...! 1102 Sales Rep 1337 Bondur Loui x6493 lbondur@classicmodelcars... 1102 Sales Rep 1401 Castillo Pamela x2759 pcastillo@classicmodelca... 4 1102 Sales Rep 1702 Gerard Martin x2312 mqerard@classicmodelcars... 4 1102 Sales Rep 1504 Jones Barry x102 bjones@classicmodelcars.com 1102 Sales Rep 1501 Bott Larry x2311 lbottlclassicmodelcars.com 7 1102 Sales Rep 1165 Jennings Leslie x3291 ljennings@classicmodelca... 1143 Sales Rep 1166 Thompson Leslie x4065 Ithompsonlclassicmodelca... 1143 Sales Rep 1188 Firrelli Julie x2173 itirrelli@classicmodelca... 1143 Sales Rep 1216 Patterson Steve x4334 spatterson classicmodelc... 2 1143 Sales Rep 1323 Vanaut George x4102 qvanauf@classicmodelcars... 1143 Sales Rep 1286 Tseng Foon Yue x228 ftsengeclassicmodelcars.com 3 1143 Sales Rep 1625 Kato Yoshimi x102 vkato@classicmodelcars.com 5 1621 Sales Rep 1002 Murphy Diane x5800 dmurphy@classicmodelcars... 1 (null) President Mgr Employeur Nubur My Frere Merle 1002 Diane Murphy 1002 Diane Murphy 1056 Mary Patterson 1056 Mary Patterson 1056 Mary Pallerson 1056 Mary Patterson 1038 William Dallerson 1088 William Patterson 1088 William Patterson 1102 Gerard Bondur 1102 Gerard Bondur 1102 Gerard Bondur 1102 Gerard Bondur 1102 Gerard Bondur 1102 Gerard Bondur 1143 Anthony Bow 1143 Anthony BOW 1143 Anthony Bow 1143 Anthony Bow 1143 Anthony Bow 1143 Anthony Bow 1621 Mami Nishi (null) (null) (null) 12 34 38 19 21 23 8. Modify the vwEmployee Manager view so the view returns only employee information for employees who have a manager. Do not DROP and recreate the view - modify it. Write a statement to view the results of the view just modified. 300% T c L- Text Shape Media Comment View Zoom Add Page Insert Table Chart Callaborate Format Document 1 2. 3 4 5 6 7 8 10 11 12 13 14 15 16 17 18 EMPLOYEENUMBER LASTNAME FIRSTNAME EXTENSION EMA OFFICECOCE REPORTSTO JOTIE Mgr Employee Number Mgr First Name Mgr Last Name 1056 Patterson Mary X4611 mpatterso@classicmodelcars.com 1002 VP S... 1002 Diane Murphy 1076 Firrelli Jeff x9273 jfirrelli@classicmodelcars.com 1 1002 VPM... 1002 Diane Murphy 1621 Nishi Mami x101 mnishi@classicmodelcars.com 5 1056 Sale... 1056 Mary Patterson 1102 Bondur Gerard x5408 gbondur@classicmodelcars.com 4 1056 Sale. 1056 Mary Patterson 1088 Patterson William x4871 wpatterson@classicmodelcars.com 6 1056 Sale.. 1056 Mary Patterson 1143 Bow Anthony x5428 abow@classicmodelcars.com 1 1056 Sale.. 1056 Mary Patterson 1611 Fixter Andy x101 afixter@classicmodelcars.com 6 1088 Sale... 1088 William Patterson 1619 King Tom x103 tking@classicmodelcars.com 6 1088 Sale 1088 William Patterson 1612 Marsh Peter x102 pmarsh@classicmodelcars.com 6 1088 Sale. 1088 William Patterson 1504 Jones Barry x102 bjones@classicmodelcars.com 7 1102 Sale... 1102 Gerard Bondur 1401 Castillo Pamela x2759 pcastillo@classicmodelcars.com 4 1102 Sale. 1102 Gerard Bondur 1702 Gerard Martin x2312 mgerard@classicmodelcars.com 4 1102 Sale. 1102 Gerard Bondur 1337 Bondur Loui x6493 lbondur@classicmodelcars.com 4 1102 Sale... 1102 Gerard Bondur 1370 Hernandez Gerard x2028 ghernande@classicmodelcars.com 1102 Sale. 1102 Gerard Bondur 1501 Bott Larry x2311 lbott@classicmodelcars.com 1102 Sale 1102 Gerard Bondur 1286 Tseng Foon Yue x228 ftseng@classicmodelcars.com 3 1143 Sale... 1143 Anthony Bow 1216 Patterson Steve x4334 spatterson@classicmodelcars.com 2 1143 Sale.. 1143 Anthony Bow 1188 Firrelli Julie x2173 jfirrelli@classicmodelcars.com 2 1143 Sale.. 1143 Anthony Bow 1166 Thompson Leslie X4065 lthompson@classicmodelcars.com 1 1143 Sale. 1143 Anthony Bow 1165 Jennings Leslie x3291 ljennings@classicmodelcars.com 1 1143 Sale 1143 Anthony Bow 1323 Vanauf George x4102 qvanauf@classicmodelcars.com 3 1143 Sale... 1143 Anthony Bow 1625 Kato Yoshimi x102 ykato@classicmodelcars.com 5 1621 Sale... 1621 Mami Nishi 19 21 22 9. Drop both vwCustomerOrder and vwEmployee Manager views