Which statement would accomplish this requirement?
A. SELECT cust_last_name Name, cust_credit_limit + 1000 “New Credit Limit” FROM customers;
B. SELECT cust_last_name AS Name, cust_credit_limit + 1000 AS New Credit Limit FROM customers;
C. SELECT cust_last_name AS “Name”, cust_credit_limit + 1000 AS “New Credit Limit” FROM customers;
D. SELECT INITCAP(cust_last_name) “Name”, cust_credit_limit + 1000 INITCAP(“NEW CREDIT LIMIT”) FROM customers;
Answer:C
Which statement would accomplish this requirement?
A. SELECT cust_last_name Name, cust_credit_limit + 1000 “New Credit Limit” FROM customers; B. SELECT cust_last_name AS Name, cust_credit_limit + 1000 AS New Credit Limit FROM customers; C. SELECT cust_last_name AS “Name”, cust_credit_limit + 1000 AS “New Credit Limit” FROM customers; D. SELECT INITCAP(cust_last_name) “Name”, cust_credit_limit + 1000 INITCAP(“NEW CREDIT LIMIT”) FROM customers;