I have a database where for each person (ID), I need to calculate the most adverse score by weight (0 is worse than a 10) by section. See SectionRollup for expected value.
For each ID and SectionTitle, what score has the highest (max) weight?
ID
SectionTitle
Score
Weight
SectionRollup...