For an inventory report, you created a work_in_progress that contains two columns, ID_number and quantity. The parent group of the work_in_progress is in_inventory which contains one column, dept_no. You added a filter of fist fifteen to total_inventory and a filter of last 20 for work_in_progress. Which records will the report return?()
- AFirst 15 dept_no values.
- BLast 20 ID_no and quantity values with the first 15 dept_no values for each work_in_progress value.
- CFirst 15 dept_no values with the last 20 ID_number and quantity values for each total_inventory value.
- DFirst 15 dept_no values and the last 20 ID_no and quantity values.
- EThe last 20 ID_number and quantity values.