10.View the Exhibit;examine the structure of the PROMOTIONS table.
来源：互联网 发布：jdbc批量insert数据 编辑：程序博客网 时间：2024/06/04 18:12
10.View the Exhibit;examine the structure of the PROMOTIONS table.
Each promotion has a duration of at least seven days .
Your manager has asked you to generate a report, which provides the weekly cost for each promotion
done to l date.
B.SELECT promo_name,(promo_cost/promo_end_date-promo_begin_date)/7 FROM promotions;
C.SELECT promo_name, promo_cost/(promo_end_date-promo_begin_date/7) FROM promotions;
D.SELECT promo_name, promo_cost/((promo_end_date-promo_begin_date)/7) FROM promotions;
答案：D
解析:这里题目的意思是要你写一个按周对每个促销活动的统计，考察的是优先级
A：错误，promo_cost/promo_end_date先执行了
B：错误，promo_cost/promo_end_date先执行了
C：错误，promo_begin_date/7先执行了
D：正确
Each promotion has a duration of at least seven days .
Your manager has asked you to generate a report, which provides the weekly cost for each promotion
done to l date.
Which query would achieve the required result?
B.SELECT promo_name,(promo_cost/promo_end_date-promo_begin_date)/7 FROM promotions;
C.SELECT promo_name, promo_cost/(promo_end_date-promo_begin_date/7) FROM promotions;
D.SELECT promo_name, promo_cost/((promo_end_date-promo_begin_date)/7) FROM promotions;
答案：D
解析:这里题目的意思是要你写一个按周对每个促销活动的统计，考察的是优先级
A：错误，promo_cost/promo_end_date先执行了
B：错误，promo_cost/promo_end_date先执行了
C：错误，promo_begin_date/7先执行了
D：正确
0 0
- 10.View the Exhibit;examine the structure of the PROMOTIONS 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.
- 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.
- 91.View the Exhibit and examine the structure of the PROMOTIONS table. Which two SQL statements woul
- 124.View the Exhibit and examine the structure of the PROMOTIONS, SALES, and CUSTOMER tables.
- 18.Examine the structure of the PROMOTIONS table:
- 8.View the Exhibit and examine the structure of the CUSTOMERS 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.
- 44.View the Exhibit and examine the structure of the ORD table.
- 52.View the Exhibit and examine the structure of the PRODUCTS table.
- 54.View the Exhibit and examine the structure of the CUSTOMERS table.
- iOS中TableView的不同类型
- 友盟分享错误记录
- 网页分析摘记
- java入门学习（12）—内部类的定义及使用初步
- 数据库编码格式utf8
- 10.View the Exhibit;examine the structure of the PROMOTIONS table.
- 文本文档批量导成表格
- 如何做好程序，卖个好价钱？价格高了没人买，低了技术支持又太麻烦。最要命的是买了拿到代码或软件又申请退款。请各位帮忙？
- [转]阿里云 Linux 安装phpredis扩展 How to install Redis and Redis php client
- centos 7 配置网络之后不能访问外网
- XML编程-SAX
- MFC使用控制台界面
- 关于Android Canvas.drawText方法中的坐标参数的正确解释
- 优化mysql实验(explain;索引)+利用 index、explain和profile优化mysql数据库查询小结
