Task 1 (15 points): A. Write an SQL statement to create a view named ReasearcherReasearchAssignmentView that shows the values of RESEARCHER.LastName as ReasearcherlastName, RESEARCHER. First-Name as ReasearcherFirstName, RESEARCHER.Phone as ReasearcherPhone, and RESEARCHe. Name as Reasearchname. Run this statement, and then test the view with an SQL SELECT statement. B. Show the number of the fruitful and evergreen Tree that researched by "Micheal" between 5 and 7 days. C. Write one DELETE statement that will delete all data for research" jack" and all of its rows in ASSIGNMENT. D. Assume that you have a table named NEW_RESEARCHER that has the columns Phone, FirstName, and LastName, in that order. Write an INSERT statement to add all of the rows from the table NEW RESEARCHER to RESEARCHER. E. Write an UPDATE statement to change the phone number of researcher with ResearcherNumber 14 and work in Jordan forest to $105-287-8420$. Run this $\mathrm{SQL}$ statement. CS.VS.957|| Task 1 (15 points): A. Write an SQL statement to create a view named ReasearcherReasearchAssignmentView that shows the values of RESEARCHER.LastName as ReasearcherlastName, RESEARCHER. First-Name as ReasearcherFirstName, RESEARCHER.Phone as ReasearcherPhone, and RESEARCHe. Name as Reasearchname. Run this statement, and then test the view with an SQL SELECT statement. B. Show the number of the fruitful and evergreen Tree that researched by "Micheal" between 5 and 7 days. C. Write one DELETE statement that will delete all data for research" jack" and all of its rows in ASSIGNMENT. D. Assume that you have a table named NEW_RESEARCHER that has the columns Phone, FirstName, and LastName, in that order. Write an INSERT statement to add all of the rows from the table NEW RESEARCHER to RESEARCHER. E. Write an UPDATE statement to change the phone number of researcher with ResearcherNumber 14 and work in Jordan forest to $105-287-8420$. Run this $\mathrm{SQL}$ statement. CS.VS.957||