#cte

#cte

First came the headaches, a feeling of pressure in the head. Then, Shane Christie started experiencing macabre hallucinations of his own death. Later, the once sociable New Zealand rugby player started getting into arguments with loved ones and towards the end paranoia consumed his trust, making him fearful and depressed. By the time Christie took his own life aged 39 in August some 10 years after he first started experiencing the headaches he was almost unrecognisable to those closest to him.

Shane Tamura, who carried out a fatal shooting attack at a Manhattan office tower housing the National Football League, showed evidence of early-stage degenerative brain disease tied to repeated blows to the head, according to New York City's chief medical examiner. The shooter had left a note at the crime scene accusing the NFL of abandoning players with head injuries and asked that his brain be examined for chronic traumatic encephalopathy.

In a span of five years, beginning in 2015, the former National Football League quarterback Erik Kramer tried unsuccessfully to die by suicide, then lost hundreds of thousands of dollars after a woman he secretly married plundered his life's earnings while he struggled to heal. Kramer nonetheless considers himself an extremely lucky man and knows his recovery both mental and physical has been extraordinary by any definition, he said in an essay shared with the Guardian.

A Common Table Expression (CTE) is a named, temporary result set defined within a single SQL statement, which helps in improving query readability and maintainability.