human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Date, Opponent, Venue, Result, Attendance, Competition, Man of the Match
###Question: On what date was the venue Away and the result was lost 6-4 (lost 9-7 on agg)?
gpt
SELECT Date FROM table WHERE Venue = away AND Result = lost 6-4 (lost 9-7 on agg)