PLEASE ANSWER ASAP!!!!

Q.1. (14 pts) Consider the following table with the give assumptions. Student (StudentID, FirstName, LastName, Gender, Age, DepartmentID) Assumptions: There is no index. There are total 150,000 rows. 2,000 rows fall within the 35 to 40 age range. There 40 rows for each page. * 100 index rows fit on a non-clustered index leaf page. a) (7 pts] Create Nonclustered Index Ixl on Student (Age); Select Student ID from Student Where Age>=35 and Age