select * from clerk where sales > all(select avg(sales) from clerk group by a_code, s_code) order by sales desc ;