How many times will John Coltrane appear in the result table?

Twice, because it matches two album itemsOnce, because a value can only appear once

Twice, because it matches two album items.