1. Return the line_price per line_unit as QUANTITY with Product_ID, Line_unit, Line_price from ORDERLINE table.
2. Return line_unit per line price as 'UNIT QUAN' with Product_ID, Line_unit, and Line_price from ORDERLINE table.
3. Return the Distinct CUS_Code from CUSTOMER table.

2.

1) List the P_Code, V_Code, and V_Name and include all products with no matching v_code.

2) List the P_Code, V_Code, and V_Name for all products and include all product rows (products without matching vendors) as well as all vendor rows (vendors without matching products)

3.

1) Return P_Descript, P_Price, and V_Code for vendor whose code is equals to 1031.

2) Return P_Descript, P_Price, and V_Code for vendor whose code is not equals to 1031.

3) Return P_Descript, P_Price, and V_Code for Product Price is equal to or less than 10.

4) Return P_Descript, P_Price, and INV_Date in which inventory stock dates occur on or after OCT 1, 2020.