资讯

精准传达 • 有效沟通

从品牌网站建设到网络营销策划,从策略到执行的一站式服务

OCP-051-008

View the Exhibit and examine the structure of the CUSTOMERS table.
Which two tasks would require subqueries or joins to be executed in a single statement? (Choose two.)
观察下面的表结构, 哪儿个任务需要在一个语句中包含子查询或者joins

OCP-051-008



A. listing of customers who do not have a credit limit and were born before 1980
B. finding the number of customers, in each city, whose marital status is 'married'
C. finding the average credit limit of male customers residing in 'Tokyo' or 'Sydney'
D. listing of those customers whose credit limit is the same as the credit limit of customers residing in the city 'Tokyo'
E. finding the number of customers, in each city, whose credit limit is more than the average credit limit of all the customers




A. select * from CUSTOMERS  where cust_credit_limit=0 and cust_year_of_birth <1980;
B. select cust_city,count(*) from CUSTOMERS  where customer_marital='married' group by cust_city;
C. select avg(cust_credit_limit) from CUSTOMERS  where customer_city in('Tokyo','Sydney');
D. select * from customers where cust_credit_limit in(select cust_credit_limit from customers where customer_city='Tokyo')
E. select count(*),customer_city from CUSTOMERS  where customer_credit_limit>(select avg(customer_credit_limit) from CUSTOMERS   )  group by customer_city;

新闻名称:OCP-051-008
本文网址:http://www.cdkjz.cn/article/posioi.html
多年建站经验

多一份参考,总有益处

联系快上网,免费获得专属《策划方案》及报价

咨询相关问题或预约面谈,可以通过以下方式与我们联系

大客户专线   成都:13518219792   座机:028-86922220