What were the notes of the All-Africa Games before 2007?
CREATE TABLE table_name_41 (notes VARCHAR, competition VARCHAR, year VARCHAR)
SELECT notes FROM table_name_41 WHERE competition = "all-africa games" AND year < 2007
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_41 (notes VARCHAR, competition VARCHAR, year VARCHAR) Question: What were the notes of the All-Africa Games before 2007? [/INST] SELECT notes FROM table_name_41 WHERE competition = "all-africa games" AND year < 2007 </s>