Principles
Functions availables
Functions on Select Statement
php
$df->select('colA')->whereColumn('colB', 'foo')->sum();
Aggregation with a Group by
php
$df->groupBy('city', Sum::col('population', as: 'totalPopulation'));
$df->selectAll()->whereColumn('city', equal: 'Paris')->groupBy('district', Sum::col('population', as: 'totalPopulation'));