When a friend of mine and I were out "plinking" one afternoon (wooded area with a good backstop), I fired a 9 mm. bullet into a 5 ½ inch tree trunk from about eight feet out, with my Smith & Wesson Model 39 9 mm. automatic, and the bullet went clear through the tree trunk, leaving a gaping hole on the far side of the tree.
Where the bullet wound up, I have no idea, except that it couldn't go far because of the bluff-side about thirty feet behind the tree.
One of the problems with a 9 mm. is that it generally goes right through the person being fired at and winds up God knows where!