user: Question: Which league had a playoffs result of a Lost Semifinal?
Columns: ['Year', 'League', 'Reg. Season', 'Playoffs', 'Avg. attendance']
Types: ['text', 'text', 'text', 'text', 'real']
Sample row: ['2005–2006', 'MISL II', '6th MISL, 10-20', 'Did Not Qualify', 3170.0]
SQL:

assistant: SELECT "League" FROM "Table" WHERE "Playoffs" = 'Lost Semifinal';