Based on the code above, list the number, name, street, and credit limit of all customers. Order the customers by name within descending credit limit
a. SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer SORT BY CreditLimit DESC, CustomerName ;
b. SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer SORT BY CreditLimit ASC, CustomerName ;
c. SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer ORDER BY CreditLimit DESC, CustomerName ;
d. SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer ORDER BY CreditLimit ASC, CustomerName ;
c
You might also like to view...
When Wilson and McCalman argued that leadership for the greater good is ultimately where ethical leadership ought to be directed, they were underscoring which principle of ethical leadership?
A. builds community B. respects others C. manifests honesty d .shows justice
In capital budgeting analyses, the net present value (NPV) method and the internal rate of return (IRR) method both assume that the reinvestment of the project's cash flows occurs at the same rate.
Answer the following statement true (T) or false (F)
Which of the following statements about mutual insurers is true?
A) They are legally organized as partnerships. B) They have a board of directors which is selected by state insurance departments. C) They are owned by their stockholders. D) They may pay dividends to their policyholders.
To manage cash flow, you should ________ and then subtract expenses you expect to incur.
A. project gross receipts B. project gross sales C. project cash receipts D. project net income