Table schema:
CREATE TABLE battle (name VARCHAR, date VARCHAR)

Question: List the name, date and result of each battle.
SQL: SELECT name, date FROM battle