65. View the Exhibit and examine the structure of the CUSTOMERS table.You have been asked to produce a report on the CUSTOMERS table showing the customers detailssorted in descending order of the city and in the descending order of their income level in each city. Which query would accomplish this task?
A. SELECT cust_city, cust_income_level, cust_last_nameFROM customersORDER BY cust_city desc, cust_income_level DESC ;B. SELECT cust_city, cust_income_level, cust_last_nameFROM customersORDER BY cust_income_level desc, cust_city DESC;C. SELECT cust_city, cust_income_level, cust_last_nameFROM customersORDER BY (cust_city, cust_income_level) DESC;D. SELECT cust_city, cust_income_level, cust_last_nameFROM customersORDER BY cust_city, cust_income_level DESC;Answer: A答案解析:参考:http://blog.iyunv.com/rlhua/article/details/12837221根据题意:sorted in descending order of the city and inthe descending order of their income level in each city.是按照城市的降序来排列,并且在每个城市中按照income level的降序来排列。即先 cust_city desc再cust_income_level DESC
版权声明:本文为博主原创文章,未经博主允许不得转载。