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 ;

Question

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 ;

Quizplus · Accepted Answer

The correct SQL statement to list the number, name, street, and credit limit of all customers and order them by name within descending credit limit is to use SELECT, FROM, and ORDER BY clauses. The ORDER BY clause should have CreditLimit first in descending order, then CustomerName in ascending order. The correct syntax is `SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer ORDER BY CreditLimit DESC, CustomerName;`. Option C is the correct SQL statement that follows this syntax.

Based on the Code Above,list the Number,name,street,and Credit Limit of All