Convert raw MySQL into Laravel 5 query

select calendars.datefield AS date,
ifnull(sum(sales.sale_total),0) as total
from sales 
right join calendars on (date(sales.created_at) = calendars.datefield)
where (calendars.datefield between (select min(date(created_at)) from sales) and (select max(date(created_at)) from sales))
group by date

Want to convert it into Laravel 5 query. I am running Laravel 5.4. Any help?

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2xApx8r
via IFTTT