You need to generate a list of all customer last names with their credit limits from theCUSTOMERS table. Those customers
Posted: Wed Jun 07, 2023 6:12 am
You need to generate a list of all customer last names with their credit limits from theCUSTOMERS table. Those customers who do not have a credit limit should appear last in the list. Winch two queries would achieve the required result? (Choose two.)
A. SELECT cust_last_name. cust_credit_limit FROM customers ORDER BY cust_credit_limit DESC:
B. SELECT cust_last_name. cust_credit_limit FROM customers ORDER BY cust_credit_limit:
C. SELECT cust_last_name. cust_credit_limit FROM customers ORDER BY cust_credit_limit NULLS LAST:
D. SELECT cust_last_name. cust_credit_limit FROM customers ORDER BY cust_last_name. cust_credit_limit NULLS LAST:
A. SELECT cust_last_name. cust_credit_limit FROM customers ORDER BY cust_credit_limit DESC:
B. SELECT cust_last_name. cust_credit_limit FROM customers ORDER BY cust_credit_limit:
C. SELECT cust_last_name. cust_credit_limit FROM customers ORDER BY cust_credit_limit NULLS LAST:
D. SELECT cust_last_name. cust_credit_limit FROM customers ORDER BY cust_last_name. cust_credit_limit NULLS LAST: