Average score per student per subject, with gaps filled

Given marks with columns student, subject and score, build a table of the MEAN score for every student and subject pair, using 0 where a pair is missing. Return student, math and science, sorted by student ascending.