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

42 votes205 views4 answers
Css center div in page
CSS
0 vote199 views2 answers
Webpack alias not working in jest
CSS
6 votes227 views3 answers
Css change background color of page
CSS
0 vote231 views1 answer
Bast css 3d images gallery code
CSS
0 vote209 views2 answers
Card css
CSS
18 votes200 views2 answers
How to make a game engine
CSS
8 votes211 views1 answer
How to get my div to centre of primary div
CSS
0 vote288 views1 answer
Bootstrap 5 sidebar class
CSS Bootstrap
7 votes201 views3 answers
Circle button html
CSS
1 vote254 views1 answer
Sass compile minified
CSS