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

56 votes266 views3 answers
Donald trump twitter
CSS
0 vote269 views2 answers
Using materialize css with react
CSS Materialize
-1 vote252 views1 answer
Select box arrow hide css in ie
CSS
0 vote244 views1 answer
Mediaquery for portrate
CSS
3 votes256 views1 answer
Watch scss to css
CSS
18 votes327 views6 answers
Install bootstrap angular 9
CSS
0 vote244 views1 answer
Change link color in wordpress
CSS
8 votes257 views4 answers
Aos css animation
CSS
1 vote229 views1 answer
-mos css
CSS
22 votes250 views5 answers
Css center grid
CSS