how can i do this sql query in llaravel

i want this sql in larave

select name , order , date  , sum (number)  from table where case = 1 groub by id_product

just want select all in table and sum column where .. and group by

via Chebli Mohamed