Summing up a column

[Bman900 (Balint2005)]

I was wondering if there was a SUM function in yii like

$query = "SELECT type, SUM(price) FROM products GROUP BY type";