Order by client_id does not work

SQL
1

I’m trying order by client_id but it not working, can someone help me with this.

select *
from invoices i
where invoice_total>(
select avg(invoice_total)
from invoices
where i.client_id=client_id
)

2

Just append order by client_id to your query.