Based on the following student-take-course schema: Student…
Based on the following student-take-course schema: Student(StudentID: integer, Name: string, Cohort: string, Gender: string) Take(StudentID: integer, CourseID: string, Grade: integer) Course(CourseID: string, CourseName: string) How many rows will the below three queries return? Assuming we have 3 cohorts and 5 courses. Query 1: Select Avg(T.Grade) as AvgGrade from Student S inner join Take T on S.StudentID = T.StudentID; Query 2: Select Avg(T.Grade) as AvgGrade from Student S inner join Take T on S.StudentID = T.StudentID group by T.CourseID; Query 3: Select Avg(T.Grade) as AvgGrade from Student S inner join Take T on S.StudentID = T.StudentID group by T.CourseID, S.CohortID.