group by query using sqlite.query() function

I have sqlite working and tested quey.

i just want to convert it into sqlitedatabase.query(); function

select distinct id, date ,sum(goal) from goal where id=0 and date = 'Sep 15, 2015' group by id, date;