Schema: CREATE TABLE battle (name VARCHAR, RESULT VARCHAR, bulgarian_commander VARCHAR)
Question: What are the name and results of the battles when the bulgarian commander is not 'Boril'
SQL: SELECT name, RESULT FROM battle WHERE bulgarian_commander <> 'Boril'