user: ### NOW ANSWER:
Question: How many games were lost by more than 27 but not more 78 with goals less than 300?
Columns: ['Season', 'Games', 'Lost', 'Tied', 'Points', 'Goals for', 'Goals against', 'Standing']
Types: ['text', 'real', 'real', 'real', 'real', 'real', 'real', 'text']
Sample row: ['1994–95', 80.0, 45.0, 11.0, 59.0, 234.0, 300.0, '6th, North']
SQL:

assistant: SELECT AVG("Games") FROM "Table" WHERE "Lost" > 27.0 AND "Points" < 78.0 AND "Goals against" < 300.0;