OK so here we go, my attempt to solve this particular database. Tell you what I can't do one of those queries though, that's an interesting discussion point because I genuinely do not think it can be done in 1 query. We shall wait for the exam board solution in due course, where I shall be gloriously vindicated or made to look like a clown.