When the home attendance is 3.123, what's the highest away attendance?
CREATE TABLE table_1816947_2 (highest_attendance_away VARCHAR, average_attendance_home VARCHAR)
SELECT highest_attendance_away FROM table_1816947_2 WHERE average_attendance_home = "3.123"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_1816947_2 (highest_attendance_away VARCHAR, average_attendance_home VARCHAR) Question: When the home attendance is 3.123, what's the highest away attendance? [/INST] SELECT highest_attendance_away FROM table_1816947_2 WHERE average_attendance_home = "3.123" </s>