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.
This question has been retained as-is due to its unique context.