SELECT Id, Name, (SELECT Id, Name, Amount, CloseDate FROM Opportunities)
FROM Account