Generate a list of all customer last names with their credit limits from the CUSTOMERS table. Customers who do not have a credit limit should appear last in the list. kindly note that customers who do not have credit card will have NULL against credit limit.Which query would achieve the required result?
Answer options
A
SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit;
B
SELECT * FROM customers;
C
SELECT cust_last_name FROM customers ORDER BY cust_credit_limit DESC;
D
SELECT cust_last_name, cust_credit_limit FROM customers;
Correct answer: SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit;
Explanation
Quick AnswerThe correct answer is SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit; because it directly addresses the core logic of Database Management.
ORDER BY cust_credit_limit sorts ascending by default, generating the required list.