HI Niyas.. I use these query but seem that something wrong

"""SELECT distinct pt.name as product ,

s.id,

s.date_order

,p.name as partner

,sum(sl.product_uom_qty) as qty

FROM public.sale_order as s

left join res_partner as p on s.partner_id=p.id

inner join sale_order_line as sl on sl.order_id= s.id

left join product_product as pp on pp.id =sl.product_id

left join product_template as pt on pt.id = pp.product_tmpl_id

where s.state='sale' and sl.order_partner_id = p.id

group by s.id,

s.date_order

,p.name

,pt.name

order by s.id """

the output repeat customers and products and does not domain quants for each customer