What late 1980s early 1990s movie features a guy shooting up his school and at the end he is dreaming in bathtub?

The movie you're thinking of is "Elephant" which was actually released in 2003, not the late 1980s or early 1990s.