多选题 以下是PRODUCT表和SHIPPING COST表的结构：
PRODUCT
---------------------------------
PRODUCT_ID NUMBER(9)
PRODUCT_NAME VARCHAR2(20)
COST NUMBER(5, 2)
RETAIL_PRICE NUMBER(5, 2)
WEIGHT NUMBER(5, 2)
SHIPPING_COST
---------------------------------
ID NUMBER(9)
LOWWEIGHT NUMBER(5, 2)
HIGHWEIGHT NUMBER(5, 2)
COST NUMBER(5, 2)
如果需要显示包括了每个产品运输价格(shipping cost)的产品名(product name)，而运输价格是通过比较SHIPPING COST表中产品重量的下限和上限来计算的。现在请问，应使用如下查询语句中的哪两个语句?
A．SELECT product_name, cost
FROM product NATURAL JOIN shipping_cost;
B．SELECT p.product_name, s.cost
FROM product p, shipping_cost s
WHERE p.product_id=s.id(+);
C．SELECT p.product_name, s.cost
FROM product p, shipping_cost s
WHERE p.weight BETWEEN s.lowweight AND s.highweight;
D．SELECT p.product_name, s.cost
FROM product p, shipping_cost s
USING (p.weight, BETWEEN s.lowweight AND s.highweight);
E．SELECT p.product name.s.cost
FROM product p JOIN shipping_cost s
ON (p.weight BETWEEN s.lowweight AND s.highweight);