Oracle Exam 1Z0-1058-22 Topic 5 Question 20 Discussion

You are building a transaction model to identify invoices with USD amounts that are greater than the supplier's average invoice amount. The order of the filters is important.

1. Add an ''Average'' Function filter grouping by ''Supplier ID'' where ''Invoice Amount'' is greater than 0.

2. Add a standard filter where ''Invoice Currency'' equals ''USD.''

3. Add a standard filter where the delivered ''Average Value'' attribute is less than ''Invoice Amount.''

What is the correct order of the filters for this transaction model?