Since this is SQL, I'm more inclined to just do subselects instead of denormalizing the data.