Based on the code shown, which query lists the number, name, street, and credit limit of all customers? The records are ordered by customer name within descending credit limit.??Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )
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

Quizplus · Accepted Answer

The correct query is "SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer ORDER BY CreditLimit DESC, CustomerName ;" because it selects the required columns (CustomerNum, CustomerName, Street, and CreditLimit) and orders the results by CustomerName within a descending CreditLimit. Option A and B are incorrect because they miss "Street" and "ORDER BY" keywords are not correctly used. Option D selecting CreditLimit in ascending order doesn't fulfill the requirement of descending order.

Based on the Code Shown, Which Query Lists the Number