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

3 votes177 views4 answers
Css keep image ratio
CSS
1 vote226 views1 answer
Linux remove files except
CSS
0 vote159 views1 answer
Css List in line
CSS
10 votes190 views3 answers
Javascript average of numbers in array
CSS
3 votes201 views4 answers
How to remove border on button click
CSS
0 vote156 views1 answer
How to use css in material ui
CSS
0 vote169 views1 answer
Td min-height not working
CSS
1 vote179 views1 answer
Place-items css property
CSS
1 vote168 views1 answer
Ionic textarea placeholder color
CSS
0 vote160 views2 answers
How to hide youtube watermark from embedded video :2021
CSS