In the Advanced Reporting tool, you want to create a query where the results meet the following criteria
* Only show one row per employee,
* 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 to this question.