Q151 Examine the description of the PRODUCTS table

Posted on by Tran Anh

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;

 

Xem thêm:

Bài viết cùng chủ đề:

0 0 đánh giá
Đánh giá bài viết
Theo dõi
Thông báo của
guest
0 Góp ý
Phản hồi nội tuyến
Xem tất cả bình luận