Question

Using Access:

Run a query or multiple queries if needed to report on final exam average based on the student's age. Give an average for all students 40 and below and an average for all students over 40.

Answer 1

Hi,

You need to perform a UNION of two queries.

SELECT AVG(marksColName)
FROM studentsTableName
WHERE ageColName <= 40

UNION ALL

SELECT AVG(marksColName)
FROM studentsTableName
WHERE ageColName > 40 ;

Replace the column names, table name as per the table schema.

Hope this helps.