SELECT data, SUM(viste) as vistetotali, SUM(accessi) as accessitotali FROM tabella WHERE data>now() - INTERVAL 1 MONTH GROUP BY data