If my child brings home that kind of result, i'll just pull him out of school for a year.
He clearly needs a mental reset and some evaluation or time to gather himself and try again, so maybe we'll fly to another country for a calm change of scenery, do a retreat, and hash it out

I'm a huge fan of asceticism to reset your mental state, so I think flying my son to a reflection retreat where we can calmly and strategically evaluate his life choices and talk about possible outcomes of each scenario away from pressure, fear, and distractions is a good start.

We stay until we come out with what needs to change on everyone's part not just his.

Children often feel helpless because adults seem to hold all the power, so it's important for us adults to acknowledge, apologise for, and correct our own failures in front of children.

The solution will likely be multi step, and may involve many people, teacher, doctor, me and his father, himself etc, but he should be party to a turnaround plan that makes clear what everyone's responsibility is, and I would always want my child to tell me if i'm not doing mine

All this beating creates so much resentment and rarely helps.

I think children should be beaten only if they are wilfully cruel, only if it will immediately stop the dangerous or cruel action, and only after extensive interventions, explanations, etc.