Solved by verified expert:Perform following tasks on the Student Alcohol Consumption data set, and then submit your answers in the blackboard (homework #2): Count all students in the tableSelect average of the final grade (G3) for all students Select sum of the final grade (G3) for all students Select average of the final grade (G3) of female students Select average of the final grade (G3) grouped by “gender”Select minimum of “G3”, maximum of “G3”, and sum of “G3” grouped by “gender”Select average of the “G3” based on (group by) the reason to choose the school. Retrieve only groups that have average score greater than 11. *Hint: “Having” should be used instead of “Where” Select all records from the table for students whose “G3s” less than the average * Hint: use subquery
