以下是产品(PRODUCT)表中的数据：
PRODUCT
|
| ID NUMBER | DESCRIPTION | MANUFACTURER ID | QUANTITY | COST |
| 215 | AAA 6pk-battery | NF10032 | 546 | 3.00 |
| 140 | AA 2pk-battery | EL7968 | 2000 | |
| 603 | D 2pk-battery | OT456 | 318 | 1.10 |
| 725 | C 2pk-battery | OT456 | 239 | .75 |
| 218 | AAA 6pk-battery | OT456 | 980 | 3.25 |
| 220 | AAA 8pk-battery | NF10032 | | 4.20 |
| 126 | AA 2pk-battery | NF10032 | 2513 | |
| 751 | C 2pk-battery | EL7968 | 84 | 100 |
SELECT description, quantity, cost
FROMproduct
WHERE manufacturer_id LIKE ’NF10032’
AND
NVL(cost, 0)＜5.00
ORDER BY quantity DESC, cost;
以上的查询语句将产生如下的哪个结果A．DESCRIPTION
QUANTITY
COST
----------------- --------- ------
AA 2pk-battery
2513
AAA 6pk-battery
546
3
B．DESCRIPTION
QUANTITY
COST
----------------- --------- ------
AAA 8pk-battery
4.2
AA 2pk-battery
2513
AAA 6pk-battery
546
3
C．DESCRIPTION
QUANTITY
COST
----------------- --------- ------
AAA 6pk-battery
546
3
AAA 8pk-battery
4.2
AA 2pk-battery
2513
D．DESCRIPTION
QUANTITY
COST
----------------- --------- ------
AA 2pk-battery
2513
AAA 6pk-battery
546
3
AAA 8pk-battery
4.2
