USE NEW_FOLDER XSTAR,'Test'
   
   NEW_FILE 'Sale.txt'
0|0
1|10
1|11
1|12
2|20
3|30
3|31
)
   
   USE 'Test'
   
   NEW_TABLE 'Sale'
	Product INTEGER
	Amount  INTEGER
)
   
   INSERT_INTO OPEN 'Sale'
   FROM FILE 'Sale.txt'
   SELECT ALL
   
   FROM 'Sale'
   WHERE 'Amount > 0'
   SELECT ALL
┌───────┬──────┐
│Product│Amount│
├───────┼──────┤
│1      │10    │
│1      │11    │
│1      │12    │
│2      │20    │
│3      │30    │
│3      │31    │
└───────┴──────┘
   
   GROUP_BY 'Product'
   SELECT 'GROUP, SUM(Amount)'
┌───────┬─────────┐
│Product│SumAmount│
├───────┼─────────┤
│1      │33       │
│2      │20       │
│3      │61       │
└───────┴─────────┘
   
   HAVING 'SUM(Amount) > 30'
   SELECT 'GROUP, SUM(Amount)'
┌───────┬─────────┐
│Product│SumAmount│
├───────┼─────────┤
│1      │33       │
│3      │61       │
└───────┴─────────┘
   CLOSE ALL