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 vote138 views1 answer
Wrap text around circle image css
CSS
0 vote148 views1 answer
Css color codes
CSS
0 vote152 views1 answer
Chrome console remove css dark mode
CSS
3 votes136 views1 answer
Install expo vector icons
CSS
1 vote139 views1 answer
303,592 HDK to pounds
CSS
0 vote141 views2 answers
Hide Categories - Woocommerce Product Page
CSS
0 vote144 views1 answer
Linux copy directory permissions to another directory
CSS
-2 votes144 views1 answer
How to add pseudo class in html
CSS
45 votes134 views6 answers
How to remove background color in css
CSS
0 vote140 views1 answer
Inexorably
CSS