MaxcomputeSQL提供了CASE…WHEN…,可以进行条件判断。表tbl中包含了字段(idbigint,agebigint),目前有三条纪录,分别为(1,20),(2,30),(3,60),执行以下SQL:selectid,casewhenage>60then‘A’whenage>40then‘B’whenage>20then‘C’else‘D’endfromtblwhereid=3;()是正确的执行结果。
A.A
B.B
C.C
D.D
A.A
B.B
C.C
D.D
第3题
B、没有区别
C、select*fromAleftouterjoinBonB.id=A.idandA.dt=20140301
D、select*fromAleftouterjoinBonB.id=A.idwhereA.dt=20140301
第5题
A.ERwin
B.Access
C.SQLServer
D.Oracle
第6题
A.在使用多路插入时,可对同一张表同时执行insertinto和insertoverwrite
B.使用动态分区插入时,动态分区列必须在select列表中
C.MaxcomputeSQL支持between子句
D.对于分区表,可指定某个分区的lifecycle,其中n为正整数,单位为天
第7题
(1)禁止在德国使用优惠券是改善了还是恶化了德国消费者的境况?
(2)禁止在德国使用优惠券是改善了还是恶化了德国生产者的境况?
In Example 11. 1 we saw how producers of processed foods and related consumer goods use coupons as a means of price discrimination. Although coupons are widely used in the United States, that is not the case in other countries. In Germany , coupons are illegal.
a Does prohibiting the use of coupons in Germany make German consumers better off or worse off?
b. Does prohibiting the use of coupons make German producers better off or worse off?
第8题
下表显示了1997和1998两年速溶咖啡和烘焙咖啡的零售价格和销售量。
(1)利用这些数据,计算烘焙咖啡需求的短期价格弹性,推导烘焙咖啡的线性需求曲线。
(2)计算速溶咖啡需求的短期价格弹性,推导速溶咖啡的线性需求曲线。
(3)哪种咖啡的短期需求弹性大?为什么是这样?
The table below shows the retail price and sales for instant coffee and roasted coffee for 1997 and 1998.
a. Using this data alone, estimate the short-run price elasticity of demand for roasted coffee.Derive a linear demand curve for roasted coffee.
b. Now estimate the short-run price elasticity of demand for instant coffee. Derive a linear demand curve for instant coffee.
c. Which coffee has the higher. short-run price elasticity of demand? Why do you think this is the case?
第9题
许多录像带零售店提供两种可选择的租片方式:
(1)两部收费法。支付一笔年度会员费(例如40美元),然后在日常租赁影片时付较低的费用(例如每片每天2美元)。
(2)直接付租赁费。不付会员费,但付较高的日租费(例如每片每天4美元)。
本例中两部收费背后的理由是什么?为什么要给顾客两种方案选择,而不是只有一种两部收费?
Many retail video stores offer two alternative plans for renting films:
a A two-part tariff: Pay an annual membership fee (e.g S40), and then pay a small fee for the daily rental of each film (e. g. $2 per film per day).
b. A straight rental fee; Pay no membership fee, but pay a higher daily rental fee (e.g $4 per film per day). What is the logic behind the two-part tariff in this case? Why offer the customer a choice of two plans, rather than simply a two-part tariff?
第10题
A.使用CASE丁以简化系统分析工作
B.CASE是开发SIM的一种环境
C.CASE用于非结构化问题
D.CASE是SIM的一种开发方法
第11题
A.as if
B.like
C.likely
D.possible