溫馨提示×

溫馨提示×

您好，登錄后才能下訂單哦！

密碼登錄×
登錄注冊×
其他方式登錄
點擊 登錄注冊 即表示同意《億速云用戶服務(wù)條款》

OCP-051-008

發(fā)布時間：2020-08-10 14:28:10 來源：ITPUB博客 閱讀：146 作者：fwinmachao 欄目：關(guān)系型數(shù)據(jù)庫
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.)
觀察下面的表結(jié)構(gòu), 哪兒個任務(wù)需要在一個語句中包含子查詢或者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;
向AI問一下細(xì)節(jié)

免責(zé)聲明：本站發(fā)布的內(nèi)容（圖片、視頻和文字）以原創(chuàng)、轉(zhuǎn)載和分享為主，文章觀點不代表本網(wǎng)站立場，如果涉及侵權(quán)請聯(lián)系站長郵箱：is@yisu.com進行舉報，并提供相關(guān)證據(jù)，一經(jīng)查實，將立刻刪除涉嫌侵權(quán)內(nèi)容。

AI
助
手