如果要显示库存超过100的所有产品(product)的产品标识号(id_number)，并且想以这样的方式来显示：首先以制造商(manufacturer)的字母顺序，之后按产品号由小到大的顺序，应该使用如下的哪个语句来完成这一工作注意所有的数据也都存放在INVENTORY表中。
A．SELECT
id_number
FROM
inventory
WHERE
quantity＞100
ORDER BY
manufacturer_id, id_number;
B．SELECT
id_number
FROM
inventory
WHERE
quantity=＞100
SORT BY
manufacturer_id, id_number;
C．SELECT
id_number
FROM
inventory
WHERE
quantity＞100
ORDER BY
manufacturer_id, id_number DESC;
D．SELECT
id_number
FROM
inventory
WHERE
quantity＞100
SORT BY
manufacturer_id, id_number;
