SOQL Functions

●AVG()

SELECT CampaignId, AVG(Amount)

FROM Opportunity

GROUP BY CampaignId

●COUNT()

SELECT COUNT() FROM Account WHERE Name LIKE 'a%'

●COUNT_DISTINCT()

SELECT COUNT_DISTINCT(Company)

FROM Lead

●MIN()

SELECT MIN(CreatedDate), FirstName, LastName

FROM Contact

GROUP BY FirstName, LastName

●MAX()

SELECT Name, MAX(BudgetedCost)

FROM Campaign

GROUP BY Name

●SUM()

SELECT SUM(Amount)

FROM Opportunity

WHERE IsClosed = false AND Probability > 60