Normalize a table and write aggregate SQL queries
Filed under ZoomRX
The question
Given a table, determine its normal form and normalize it if necessary. Write SQL queries to retrieve students scoring above 50 in any subject without duplicates, and to find student names with an overall average mark greater than 50, for both original and normalized schemas.
No write-up yet. Related questions below have one.
Collected from public candidate posts and coding forums. Updated Nov 2026.