149.View the Exhibits and examine the structures of the COSTS and PROMOTIONS tables.
来源：互联网 发布：百会软件 编辑：程序博客网 时间：2024/04/30 20:14
149.View the Exhibits and examine the structures of the COSTS and PROMOTIONS tables.
Evaluate the following SQL statement:
SQL> SELECT prod_id FROM costs
WHERE promo_id IN (SELECT promo_id FROM promotions
WHERE promo_cost < ALL
(SELECT MAX(promo_cost) FROM promotions
GROUP BY (promo_end_date-
promo_begin_date)));
What would be the outcome of the above SQL statement?
A.It displays prod IDs in the promo with the lowest cost.
B.It displays prod IDs in the promos with the lowest cost in the same time interval.
C.It displays prod IDs in the promos with the highest cost in the same time interval.
D.It displays prod IDs in the promos with cost less than the highest cost in the same time interval.
答案：D
解析：用到了group by(promo_end_date-promo_begin_date),所以是in the same time interval，因此选择D
Evaluate the following SQL statement:
SQL> SELECT prod_id FROM costs
WHERE promo_id IN (SELECT promo_id FROM promotions
WHERE promo_cost < ALL
(SELECT MAX(promo_cost) FROM promotions
GROUP BY (promo_end_date-
promo_begin_date)));
What would be the outcome of the above SQL statement?
A.It displays prod IDs in the promo with the lowest cost.
B.It displays prod IDs in the promos with the lowest cost in the same time interval.
C.It displays prod IDs in the promos with the highest cost in the same time interval.
D.It displays prod IDs in the promos with cost less than the highest cost in the same time interval.
答案：D
解析：用到了group by(promo_end_date-promo_begin_date),所以是in the same time interval，因此选择D
0 0
- 149.View the Exhibits and examine the structures of the COSTS and PROMOTIONS tables.
- 129.View the Exhibits and examine the structures of the PROMOTIONS and SALES tables.
- 153.View the Exhibits and examine the structures of the PRODUCTS and SALES tables.
- 120.View the Exhibits and examine the structures of the PRODUCTS, SALES, and CUSTOMERS
- 123.View the Exhibits and examine the structures of the PRODUCTS, SALES, and CUSTOMERS
- 137.View the Exhibits and examine PRODUCTS and SALES tables.
- 124.View the Exhibit and examine the structure of the PROMOTIONS, SALES, and CUSTOMER tables.
- 168.View the Exhibit and examine the description of SALES and PROMOTIONS tables.
- 154.View the Exhibit and evaluate structures of the SALES, PRODUCTS, and COSTS tables.
- 166.View the Exhibit and examine the structures of the EMPLOYEES and DEPARTMENTS tables.
- 56.View the Exhibit and examine the structure of the PROMOTIONS table.
- 61.View the Exhibit and examine the structure of the PROMOTIONS table.
- 99.View the Exhibit and examine the structure of the PROMOTIONS table.
- 100.View the Exhibit and examine the structure of the PROMOTIONS table.
- 112.View the Exhibit and examine the structure of the PROMOTIONS table.
- 118.View the Exhibit and examine the structure of the PROMOTIONS table.
- 143.View the Exhibit and examine the structure of the PROMOTIONS table.
- 147.View the Exhibit and examine the structure of the PROMOTIONS table.
- PCA （主成分分析）详解 （写给初学者） 结合matlab
- C++第二次实验
- PHP-Zend引擎剖析之CV变量
- ES6中Set和WeakSet的使用
- 数字分割
- 149.View the Exhibits and examine the structures of the COSTS and PROMOTIONS tables.
- xcode实用功能
- C++上机报告2
- C++第一次上机-1
- 5 Javascript:循环-for
- 批量探测主机是否存活
- 开篇
- android service 生命周期
- 基于Android的ELF PLT/GOT符号重定向过程及ELF Hook实现
