My oscar used to jump for shrimp. It would completely clear the water, about 10" above my tank...which made water go everywhere, but it was a dormitory and my friends liked to watch it so I didn't care.
I also had a goldfish that would slap its side against its plastic tank, making a "gong" sound whenever it was hungry...which was about once per day. It would continue until I fed it and it stopped after.
A grouper in the marine lab I worked at would splash tour groups...but nobody taught it to do that...