i want to convert PostgreSQL Query into Laravel builder

select created_at::date, count(id) from transactions WHERE created_at::date <= '2021-03-18' and created_at::date >= '2021-03-11' and merchant_id = 3 GROUP BY created_at::date

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3cYvXV2
via IFTTT