What is the listed year that has a rank smaller than 8 and moving from Olympiacos?
CREATE TABLE table_name_64 (year VARCHAR, rank VARCHAR, moving_from VARCHAR)
SELECT year FROM table_name_64 WHERE rank < 8 AND moving_from = "olympiacos"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_64 (year VARCHAR, rank VARCHAR, moving_from VARCHAR) Question: What is the listed year that has a rank smaller than 8 and moving from Olympiacos? [/INST] SELECT year FROM table_name_64 WHERE rank < 8 AND moving_from = "olympiacos" </s>