How to use Group By in chart

I have a requirement to display a chart that group records daily so i will have the sum value of column daily.
in mySQL i use something like this

SELECT    DATE(datetime) as DATE, SUM(`count`) totalCOunt
FROM      tableName
GROUP BY  DATE(datetime)

how can i do this in wappler?