Schema: CREATE TABLE battle (name VARCHAR, date VARCHAR)
Question: List the name, date and result of each battle.
SQL: SELECT name, date FROM battle