a$.$ A university database system needs to analyze the performance of students within the 'Computer Science' department. To facilitate this analysis, the decision has been made to create a new table, cs$\_$student$\_$performance, that will contain records from the students table but only for those who are majoring in 'Comp. Sci.$\text{'}.$ Write an SQL statement to create the cs$\_$student$\_$performance table based on the schema and data of the students table, ensuring it only includes students from the 'Comp. Sci.$\text{'}$ department.

b$.$ Further, it's decided that query performance on this new table cs$\_$student$\_$performance should be optimized. Specifically, queries are expected to frequently search by student id or by by tot$\_$cred. Write SQL statements to create an index on the student id and tot$\_$cred columns to optimize query performance.LAM.pdf