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;
Detailed Solution & Conceptual Analysis
This question has been retained as-is due to its unique context.
Key Engineering Takeaway
In Database Management, understanding the underlying mechanics of Database Management is critical for writing performant, bug-free production code and passing rigorous technical architecture reviews.