Foraninventoryreport,youcreatedawork_in_progressthatcontainstwocolumns,ID_numberandquantity.Theparentgroupofthework_in_progressisin_inventorywhichcontainsonecolumn,dept_no.Youaddedafilteroffistfifteentototal_inventoryandafilteroflast20forwork_in_progress.Whichrecordswillthereportreturn?（）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.

单项选择题

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.

1Z0-132