The FrequentPaths function outputs the sequences that start start with 'A' and end with 'C'.
SELECT * FROM frequentPaths ( ON (select 1) PARTITION BY 1 InputTable ('nPath_output') OutputTable ('output7') PartitionColumns ('id') PathColumn ('path') MinSupport ('2') );