how to mixing aggregate and non aggregate in influxdb code example

Example: how to mixing aggregate and non aggregate in influxdb

SELECT sum(value)  AS value INTO collectd_db."ten_min_sum".rain FROM collectd_db."default".rain where time >= now() - 7d GROUP BY time(10m), *