For this homework, please write down the SQL statement to complete the 10 tasks/queries.
Please consider the following hypothetical database schema. Suppose all students have a unique student ID (SID) and each faculty is identified by a unique Social Security Number (SSN). Every course has a unique course number (CID). The relation ENROLLS represents all the courses took by a student in a specific semester.