Find all Account records which have an associated Opportunity which has been lost

select id, name ,(select id from opportunities where StageName='Closed Won') from account