Top 10 customers odoo

query = "select sum(s.amount_total) as total , s.partner_id,
c.name from sale_order as s inner join res_partner as c 
on s.partner_id =c.id  group by s.partner_id,c.name
order by total desc"
//this will return the sum of amount_total group by custmer name ,
//you need to put this value inside the  self.env.cr.execute(query)

Similar codes

1 vote137 views1 answer
Css media queries between two sizes
CSS
0 vote127 views1 answer
Iterating data font size as to be decreased in Angular by using css
CSS
0 vote121 views1 answer
Values play state animation css
CSS
0 vote135 views1 answer
Media screen desktop
CSS
1 vote128 views1 answer
Why is my css code not working
CSS
0 vote138 views1 answer
Css grid no stretch
CSS
2 votes117 views5 answers
Figma
CSS
0 vote121 views1 answer
P::after p::before css
CSS
98 votes124 views6 answers
Css center
CSS
7 votes114 views3 answers
Bootstrap remove outline
CSS