from the Real World
It was track 2 on side A of that record.
The song was completely instrumental, and it had no lyrics, but there were parts of the song that some fans often would sing "Superman!" at times.
Despite having no lyrics, anyone who is familiar with cinema in the last several decades would instantly recognize it. It's as familiar as the Star Wars theme, which was also written by John Williams.