We want to get the matching medal for each athlete. How might we achieve that?

By joining on the common property, nameBy only selecting the medal column from awardBy joining on the common property medal

By joining on the common property, name.