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?()
A.First 15 dept_no values.
B.Last 20 ID_no and quantity values with the first 15 dept_no values for each work_in_progress value.
C.First 15 dept_no values with the last 20 ID_number and quantity values for each total_inventory value.
D.First 15 dept_no values and the last 20 ID_no and quantity values.
E.The last 20 ID_number and quantity values.