create intermediate table between shots and challenge
Create Challenge_shot