SQL Aggregates

SQL Query Analysis with Schema Schema: student(rollNo, name, degree, year, sex, deptNo, advisor): deptNo: Foreign key referencing deptId in the department relation. advisor: Foreign key referencing empId in the professor relation. department(deptId, name, hod, phone): hod: Foreign key referencing empId …