Laravel по-русски

не как не получается переборозовать sql запрос на Laravel 5.3 Eloquent

SELECT f.id as film,s.id as sid,f.name,f.description,f.avatar, count(s.id) as sc,count(t.id) as busy from films as f LEFT JOIN sessions as s on f.id = s.f_id  LEFT join tickets as t on s.id=t.s_id
GROUP BY sid HAVING sid IS NOT NULL

пожалуйста помогите !!!!!!!