The CUSTOMERS table has the following structure:
Exhibit:
You need to write a query that does the following task:
* Display the first name and tax amount of the customers. Tax is 5% of their credit limit
* Only those customers whose income level has a value should be considered
* Customers whose tax amount is null should not be considered
Which statement accomplishes all the required tasks?
A. SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customersWHERE cust_income_level IS NOT NULL ANDtax_amount IS NOT NULL;
B. SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customersWHERE cust_income_level IS NOT NULL ANDcust_credit_limit IS NOT NULL;
C. SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customersWHERE cust_income_level <> NULL ANDtax_amount <> NULL;
D. SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customersWHERE (cust_income_level,tax_amount) IS NOT NULL;
|
Download Printable PDF. VALID exam to help you PASS. |
 |