sum of columns in sql with where clause code example Example: sql sum and other fields SELECT sum(a) as car,b,c FROM toys GROUP BY b, c