ID FirstName LastName ReportsTo Position Age1 Daniel Smith Bob Boss Engineer 252 Mike White Bob Boss Contractor 223 Jenny Richards null CEO 454 Robert Black Daniel Smith Sales 225 Noah Fritz Jenny Richards Assistant 306 David S Jenny Richards Director 327 Ashley Wells David S Assistant 258 Ashley Johnson null Intern 25

ID FirstName LastName ReportsTo Position Age1 Daniel Smith Bob Boss Engineer 252 Mike White Bob Boss Contractor 223 Jenny Richards null CEO 454 Robert Black Daniel Smith Sales 225 Noah Fritz Jenny Richards Assistant 306 David S Jenny Richards Director 327 Ashley Wells David S Assistant 258 Ashley Johnson null Intern 25

St BarnabasChair -Mrs Chikorwa 0773043040Vice chair-Tinotenda Tiki 078145356313:41Sacred Heart+263 71 481 8553Sacred Heart+263 71 481 8553St BarnabasChair -Mrs Chikorwa 0773043040Vice chair-Tinotenda Tiki 0781453563Secretary -Tete Betty kudzika 0775479688Vice secretary -Yvonne Makaya 0780502210Treasurer -Mrs Duri 0714818553Promotor-Mrs Maora 0777592504

Student_IDFirst_NameLast_NameDOBEmailMajorAllowance1JohnDoe2001-01-15john.doe@example.comComputer [email protected] Administration40003AliceJohnson2001-11-25alice.johnson@example.comElectrical [email protected] Engineering35405CarolBrown1988-07-12carol.brown@example.comBusiness Administration60006AyeyiDjan1999-04-02ayeyi.djan@ashesi.edu.ghComputer Science8000 Student_IDScore180272310425590660 Flag question: Question 3Question 3Tips5 ptsThe Mastercard Foundation wants to find the majors are being paid an allowance greater than 7000. Write a MySQL statement to show this.

Student_IDFirst_NameLast_NameDOBEmailMajorAllowance1JohnDoe2001-01-15john.doe@example.comComputer [email protected] Administration40003AliceJohnson2001-11-25alice.johnson@example.comElectrical [email protected] Engineering35405CarolBrown1988-07-12carol.brown@example.comBusiness Administration60006AyeyiDjan1999-04-02ayeyi.djan@ashesi.edu.ghComputer Science8000 Student_IDScore180272310425590660 Flag question: Question 3Question 3Tips5 ptsDr Stephane Nwolley wants to identify the students with a score greater than the average. Write a MySQL statement to identify these students. Display the student names (Join first name and last name and call it full_name), the score of the student, and their major.View keyboard shortcutsEditViewInsertFormatToolsTable12ptPreformattedprecodeView keyboard shortcutsAccessibility checker24 words</>Switch to the html editorFullscreen Flag question: Question 4Question 4Tips5 ptsAshesi wants to collaborate with MTN to be able to send students SMS when they receive their allowance. Write a MySQL statement to make a view called allowance_view that displays the student's full name in one column, their major, and their allowance.

Student_IDFirst_NameLast_NameDOBEmailMajorAllowance1JohnDoe2001-01-15john.doe@example.comComputer [email protected] Administration40003AliceJohnson2001-11-25alice.johnson@example.comElectrical [email protected] Engineering35405CarolBrown1988-07-12carol.brown@example.comBusiness Administration60006AyeyiDjan1999-04-02ayeyi.djan@ashesi.edu.ghComputer Science8000 Student_IDScore180272310425590660 Flag question: Question 3Question 35 ptsDr Stephane Nwolley wants to identify the students with a score greater than the average. Write a MySQL statement to identify these students. Display the student names (Join first name and last name and call it full_name), the score of the student, and their major.