SELECT * FROM FPGrowth (
ON (SELECT 1)
PARTITION BY 1
InputTable ('sales_transaction')
OutputRuleTable ('fpgrowth_out_rule')
OutputPatternTable ('fpgrowth_out_pattern')
TranItemColumns ('product')
TranIDColumns ('orderid')
GroupByColumns ('region')
MinSupport (0.01)
MinConfidence (0.0)
MaxPatternLength (4)
ConsequenceCountRange ('1-1')
PatternsOrRules ('both')
);