Given query: Find all the names and phone numbers of the stu…
Given query: Find all the names and phone numbers of the student who take classes in Summer 2025 and in ‘Biology’ department. A.) Create the SQL command for this query? (3 Points) B.) According to the SQL command, create the relational algebra expression? (3 Points) C.) According to relational algebra expression, create an optimized relational expression tree? (4 Points) Please upload file to answer the question.