Salesforce Platform Developer I Certification Guide

SOQL aggregate, optional clauses, and return

In query languages, you can also select aggregate results from data in your database. A simple customer requirement might be, how many accounts do I have in my database that had no opportunity in the last year? We will probably, we need to set these accounts as inactive.

You are able to use some aggregate functions in a GROUP BY clause in SOQL queries to generate analytical reports. Aggregate functions are functions for performing small calculations of a list of records, such as calculating the average of the amount of a list of opportunities or counting the maximum value in a list of records (what was the hottest day in March, 2019?). The most used aggregate functions are as follows:

• AVG(): The ...