What else must you do?

In the Advanced Reporting tool, you want to create a query where the results meet the following criteria

• Only show one row peremployee,

• Only show the pay components Base Salary and Bonus,

• Show these pay components as individual columns.

You have joined the Global Job Information table with the Compensation table.

What else must you do? Note: There are 2 correct answers tothis question.
A . Configure a table restriction of the Compensation table.
B. Duplicate the Compensation table.
C. Configure a table restriction of the Global Job Information table.
D. Change the table join to the Compensation table to an inner join.

Answer: A,C