|
Title: Based on the code above, list the number, name, street, and credit limit of all customers. Order the ... Post by: arock1 on Jan 31, 2018 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 ; Title: Based on the code above, list the number, name, street, and credit limit of all customers. Order the ... Post by: leannaolsen on Jan 31, 2018 Content hidden
|