136.View the Exhibit and examine the structure of the PRODUCTS table.
来源:互联网 发布:反应釜换热计算软件 编辑:程序博客网 时间:2024/05/17 02:21
136.View the Exhibit and examine the structure of the PRODUCTS table.
Which two tasks would require subqueries? (Choose two.)
A.Display the minimum list price for each product status.
B.Display all suppliers whose list price is less than 1000.
C.Display the number of products whose list price is more than the average list price.
D.Display the total number of products supplied by supplier 102 and have product status as 'obsolete'.
E.Display all products whose minimum list price is more than the average list price of products and have the status 'orderable'.
答案:CE
解析:
A:select prod_status,min(prod_min_price) from PRODUCTS group by prod_status
B:select prod_name from PRODUCTS where prod_list_price <1000;
C:select count(*) from PRODUCTS where prod_list_price>select avg(prod_list_price) from PRODUCTS
D:select count(*) from PRODUCTS where prod_id=102 and prod_status='obsolete'
E:select prod_pname from PRODUCTS where prod_status='obsolete' group by prod_pname having min(prod_min_price)>select avg(prod_list_price) from PRODUCTS
Which two tasks would require subqueries? (Choose two.)
A.Display the minimum list price for each product status.
B.Display all suppliers whose list price is less than 1000.
C.Display the number of products whose list price is more than the average list price.
D.Display the total number of products supplied by supplier 102 and have product status as 'obsolete'.
E.Display all products whose minimum list price is more than the average list price of products and have the status 'orderable'.
答案:CE
解析:
A:select prod_status,min(prod_min_price) from PRODUCTS group by prod_status
B:select prod_name from PRODUCTS where prod_list_price <1000;
C:select count(*) from PRODUCTS where prod_list_price>select avg(prod_list_price) from PRODUCTS
D:select count(*) from PRODUCTS where prod_id=102 and prod_status='obsolete'
E:select prod_pname from PRODUCTS where prod_status='obsolete' group by prod_pname having min(prod_min_price)>select avg(prod_list_price) from PRODUCTS
0 0
- 136.View the Exhibit and examine the structure of the PRODUCTS table.
- 11.View the Exhibit and examine the structure of the PRODUCTS table.
- 13.View the Exhibit and examine the structure of the PRODUCTS table.
- 52.View the Exhibit and examine the structure of the PRODUCTS table.
- 63.View the Exhibit and examine the structure of the PRODUCTS table.
- 142.View the Exhibit and examine the structure of the PRODUCTS table.
- 144.View the Exhibit and examine the structure of the PRODUCTS table.
- 1.View the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS, and TIMES tables.
- 132.View the Exhibit and examine the structure of the SALES and PRODUCTS tables.
- 162.View the Exhibit and examine the structure of the PRODUCTS, SALES, and SALE_SUMMARY tables.
- 148.View the Exhibit and examine the structure of the PRODUCTS tables.
- 8.View the Exhibit and examine the structure of the CUSTOMERS table.
- 44.View the Exhibit and examine the structure of the ORD table.
- 54.View the Exhibit and examine the structure of the CUSTOMERS table.
- 56.View the Exhibit and examine the structure of the PROMOTIONS table.
- 61.View the Exhibit and examine the structure of the PROMOTIONS table.
- 65.View the Exhibit and examine the structure of the CUSTOMERS table.
- 84.View the Exhibit and examine the structure of the EMPLOYEES table.
- UVa 455 Periodic Strings【最小循环子串】
- Android 设置StatusBar的颜色
- Golang加头和尾部来解决tcp粘包问题.代码片段示例
- vmware虚拟机中ubuntu上网问题
- hibernate 接收参数
- 136.View the Exhibit and examine the structure of the PRODUCTS table.
- 我的第二次找工作之旅
- css记忆
- GridView使用BaseAdapter实现网格视图
- 启发式算法
- win7 64位下wampserver打开php扩展php_oci8和php_pdo_oci失败的问题
- HUST 1606 - Naive
- 通信协议:HTTP、TCP、UDP
- elasticsearch Windows安装