A data engineer is performing a complex aggregation on a table that contains no null values, and their query returns the following result: //IMG//

Which of the following queries was used to produce this result?