Needed in MS SQL / SQL access URGENTLY Thanks

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