Returns the total value of a numeric field:
SELECT SUM(Amount) FROM Opportunity
SELECT SUM(Amount) FROM Opportunity WHERE IsClosed = false AND Probability > 60