i need to display the average GPA of both Male nd Female students but after writing the statement i keep getting an error message
This is the select statement
Select AVG(GPA) AS "AVG(GPAM)",
Gender
From Students = 'M'
Select AVG(GPA) AS "AVG(GPAF),
Gender
From Students
Where Gender = 'F'
but then i keep getting this error message
Msg 8120, Level 16, State 1, Line 1
Column 'Students.Gender' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.