Try this:
select name, sum(profit)
from yourtable
WHERE
date >= '2014-04-19 00:00:00'
AND
date < '2014-04-19 23:59:59'
group by name
solved MySQL Name Profit with date range [closed]
Try this:
select name, sum(profit)
from yourtable
WHERE
date >= '2014-04-19 00:00:00'
AND
date < '2014-04-19 23:59:59'
group by name
solved MySQL Name Profit with date range [closed]