user: ### NOW ANSWER:
Question: What is the average number of losses when there are more than 0 ties?
Columns: ['Opposition', 'Span', 'Lost', 'Tied', 'Success Rate']
Types: ['text', 'text', 'real', 'real', 'text']
Sample row: ['Chennai Super Kings', '2008–2013', 8.0, 0.0, '35.71%']
SQL:

assistant: SELECT AVG("Lost") FROM "Table" WHERE "Tied" > 0.0;