purchases:readcsv["country,amount,discount\n",read["headerless.csv"] "sii"] purchases:readcsv[read["purchases.csv"] "sii"]
sum purchases.amount
select first country sum amount by country from purchases
select first country sum amount-discount by country from purchases
stats:first import["stats.deck"]
select first country sum amount-discount by country where amount<stats.median[amount]*10 from purchases
select first country sum amount-discount where amount<stats.median[amount]*10 by country from purchases l_inner:l[1][1]
# {"age":3}
l_inner.age:9
# {"age":9}
l_inner
# {"age":9}
l
# (1,(2,{"age":3}),4)
(1,(list 2,list ().age:5),4)[1][1].age:99
# (1,(2,{"age":99}),4) cat.age:3
# {"age":3}
l:1,(list 2,list cat),4
# (1,(2,{"age":3}),4)
l[1][1].age:9
# (1,(2,{"age":9}),4)
cat
# {"age":3}
l:l,5
# (1,(2,{"age":9}),4,5)