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

0 vote284 views2 answers
Elementor accordion closed by default
CSS
0 vote313 views1 answer
How to center an item without flex
CSS
5 votes273 views2 answers
How to make a diamond with border radius
CSS
4 votes323 views1 answer
Scss sass on hover pseudo-class
CSS
7 votes255 views3 answers
Css wrap text to next line
CSS
12 votes279 views3 answers
Line through in css
CSS
-1 vote274 views1 answer
Focus on input change label color
CSS
0 vote334 views1 answer
Progress bar bootstrap border
CSS Bootstrap
0 vote247 views3 answers
Image not rendering in tailwind css
CSS
0 vote270 views1 answer
On frontend grivity form css not load
CSS