Q151 Examine the description of the PRODUCTS table

Q151 Examine the description of the PRODUCTS table

Which three queries use valid expressions?

• A) SELECT product_id, unit_price || 5 “Discount”, unit_price + surcharge – discount FROM products;
• B) SELECT product_id, unit_price, unit_price + surcharge FROM products;
• C) SELECT product_id, unit_price, 5 “Discount”, unit_price + surcharge – discount FROM products;
• D) SELECT product_id, expiry_date * 2 FROM products;
• E) SELECT product_id, (unit_price * 0.15/ (4.75 + 552.25)) FROM products;
• F) SELECT product_id, (expiry_date – delivery_date) * 2 FROM products;