Formulate an answer to this elaborate question: On what studio album was the song which surpassed the song "Once a Day" for the record for the most weeks spent at number one by a female country artist?
Red