历年销售额均在前15位的客户

从数据库中的SALES表中获得销售数据,找出历年销售额均在前15位的客户有哪些。

解答:

A
1
=demo.query("select * from SALES")
2
=A1.group(year(ORDERDATE))
3
=A2.(~.group(CLIENT))
4
=A3.(~.new(CLIENT,~.sum(AMOUNT):Amount))
5
=A4.(~.sort@z(Amount).select(#<=15))
6
=A5.(~.(CLIENT))
7
=A6.isect()

A7中运算结果如下: