Q19 You want to display the first name and due amount as 5% of their credit limit

Posted on by Tran Anh

Q19 Examine the description of the CUSTOMERS table:

For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.

Which query should be used?

  • (A). SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level IS NOT NULL AND due_amount IS NOT NULL;
  • (B). SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customers WHERE cust_income_level != NULL AND cust_credit_level !=NULL;
  • (C). SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customers WHERE cust_income_level <> NULL AND due_amount <> NULL;
  • (D). SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customers WHERE cust_income_level != NULL AND due_amount != NULL;
  • (E). SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level IS NOT NULL AND cust_credit_limit IS NOT NULL;

 

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