The exhibit shows a query and the four tables it uses. The query will select data about orders by customers from California and _______.
A.
the ORDERNUM and CUSTNUM are reported
B.
the price for the total quantity ordered is computed for all orders
C.
the price for the total quantity ordered is computed for each order number
D.
the ORDERNUM and PARTNUM are reported