Please answer the following question: Formulate an answer to this elaborate question: Greatest Hits 1978-1997 is the second DVD by an American rock band formed in what city?
A:
San Francisco