Table is as follows:
Sales department business lines
1001, 002, 20
1002, 003, 30
1001 001 40
1003, 001, 50
1002 002 40
1003, 004, 60
1001 004 40
According to the selected sales amount is greater than or equal to 100 by the department of subsidiary, is only 70, 1002 sales department need to filter out, the following
Sales department business lines
1001, 002, 20
1001 001 40
1003, 001, 50
1003, 004, 60
1001 004 40