Based on the Code Shown, Which Query Lists the Number

question 30

Multiple Choice

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 ;

---

Definitions:

Caffeine

A stimulant chemical found in coffee, tea, and various other foods and drinks that affects the central nervous system, enhancing alertness and reducing fatigue.

Tobacco

A plant product containing nicotine which can be used in various forms, including smoking and chewing, often associated with health risks.

Benzodiazepines

A class of psychoactive drugs used primarily for treating anxiety, seizures, insomnia, and for inducing relaxation before surgeries.

Barbituric Acid

An organic compound used in the synthesis of barbiturate drugs, which act as central nervous system depressants.