clear`
table`sales
link[`product;`sku]`sku
define[`trans_by_date]"g_ucount[+(date;store;description);_n]transid"
select"g_first[+(date;store;description);_n]_n"
define[`rank]"g_rank[+(date;store);_n;_n]trans_by_date"
group[`description`rank;.+(`count`store;((count;`rank);(first;`store)))]
project[`T]()
show get`T
goto 1
select"promo_flag=1"
project[`U]`promo_flag
show get`U
goto -3
define[`foo]"date+1"
project[`V]`product`date
show get`V
goto -3
define[`trans_by_date]"g_ucount[+(date;store;description);_n]transid"
show get`T