I have a query in normal SQL below and I want to change it into artisan tinker query,
select count(P.id), DATEDIFF(P.tarehe_ya_kujifungua,P.tarehe_ya_kuzaliwa) as
umri from postnatals P INNER JOIN register13s R ON P.namba_ya_kadi_RCH4 =
R.Namba_ya_kadi WHERE EXTRACT(MONTH FROM tarehe_ya_hudhurio) = EXTRACT(MONTH
FROM '2018-06-12') group by P.id HAVING count(DISTINCT R.hudhurio) > 1 AND
umri >= 7305;
I have a model Postnatal.php
for postnatals
table and also I have Register13.php
for register13s
table.