Question 7 • Introduction to Information Technology - EL3701
To form useful review groups, Samantha needs to combine each student’s score with their schedule so she can identify both who needs review and when they are available. A complex query can link the two tables using student name, then sort the results and group students by a suitable study period. Sorting scores alone or grouping scores by name does not account for availability, while retrieving only scores below 65 leaves out the scheduling information.
AI-written and checked against the verified answer.