Chris Green and Nic Maddinson forged the game-winning partnership as the Sydney Thunder stunned the Melbourne Renegades at ENGIE Stadium.