题目内容

以下各题使用如下3个数据库表: 职员.dbf:职员号C(3),姓名C(6),性别C(2),组号N(1),职务C(10) 客户.dbf:客户号C(4),客户名C(36),地址C(36),所在城市C(36) 订单.dbf:订单号C(4),客户名C(4),职员号C(3),签订日期D,金额N(6.2) 查询订单数在3个以上、订单的平均金额在200元以上的职员号,正确的SQL语句是( )。

A. SELECT 职员号 FROM 订单 GROUP BY 职员号 HAVING COUNT(*)>3 AND AVG_金额>200
B. SELECT 职员号 FROM 订单 GROUP BY 职员号 HAVING COUNT(*)>3 AND AVG(金额)>200
C. SELECT 职员号 FROM 订单 GROUP BY 职员号 HAVING COUNT(*)>3 WHERE AVG(金额)>200
D. SELECT 职员号 FROM 订单 GROUP BY 职员号 WHERE COUNT(*)>3 AND AVG 额>200

查看答案
更多问题

为了保护海边建筑免遭海洋风暴的袭击,海洋度假地在海滩和建筑物之间建起了巨大的防海墙。这些防海墙不仅遮住了一些建筑物的海景,而且使海岸本身也变窄了。这是因为在风暴从水的一边对沙子进行侵蚀的时候,沙子不再向内陆扩展。 以下哪项如果为真,最能支持上述论断( )

A. 由于海洋风暴的猛烈程度不断加强,必须在海洋和海边财产之间建立起更高大的防海墙
B. 对于一个想要维护自己海滩疗养地功能的海边社区来说,通过建筑防海墙来保护海边建筑的努力,从长远来看,其作用是适得其反的
C. 用来保护海边建筑的防海墙如果要保护那些建筑,它们自己必须最终不会被风暴破坏,也不需要昂贵的维修和更新
D. 为以后的时代保留下的海滩应该是海岸管理的首要目标

Your eye is a window on the nerves and blood vessels, revealing vital information about your entire body. An (1) exam starts from the outside and works in. First the ophthalmologist (眼科医生) gauges (2) with the familiar wall chart and checks visual field by moving objects in and out of (3) . A limited visual field could be the (4) of the high inner eye pressure of glaucoma(青光眼)or (5) a tumor pressing on nerves leading from the eye. The physician also checks for infection around the lashes and notes how fast the lids follow the eyes downward. Lid lag sometimes (6) thyroid disease (甲状腺疾病).If one pupil contracts (7) the other doesn’t, the physician is (8) to the fact that (9) a tumor or stroke, perhaps, has damaged the nerves between the eye and brain. A tumor as far away (10) the lung can cause capillary problems by hitting a nerve that loops through the neck.The white of the eye, tear ducts, lens and retina (视网膜) are checked for (11) of trouble. Too many white blood cells (12) inflammation, blood means tissue has tom or a vessel has burst, and deposits of (13) material can mean eye disease. The orange-red retina holds many more (14) for disease detection. High blood pressure may announce its (15) by pushing the vessels off track at their intersections. (16) vessel growth is a sign of diabetic retinopathy (糖尿病性视网膜病). Narrowed vessels may indicate (17) of the arteries, and damage to tiny capillaries could be a sign of early diabetes.The doctor even examines the pin-head-size hole in the back of the optic nerve on their way to the brain. (18) the appearance of these nerve fibers is abnormal, nerve tissue may have been damaged because of intraocular pressure, indicating glaucoma or the presence of a tumor. When a physician needs quick, (19) information about the body, the eyes have (20) . Read the following text. Choose the best word(s) for each numbered blank and mark A, B, C or D on ANSWER SHEET 1.12()

A. effect
B. infer
C. signify
D. cause

饮食影响药品疗效的机制 以牛奶送服左旋多巴

A. 作用相悖,茶碱可加快心率
B. 酸化尿,易在尿道中形成结晶
C. 肠内产生大量氨基酸,阻碍吸收
D. 抑制乙醛脱氢酶,出现双硫仑样反应
E. 酸化尿、排泄慢、减弱活性、加重毒性

办公人员的座椅高度是非常有讲究的。专家______,许多人办公座椅的高度都存在一定问题,久坐会______疲劳感,并出现腰酸背痛的毛病。正确的做法是:首先根据工作性质把办公桌调整到一个______的高度,然后再依据自身情况来调整座椅的高度。 填入画横线部分最恰当的一项是( )。

A. 提出 产生 适合
B. 提出 引发 合适
C. 提醒 产生 合适
D. 提醒 引发 适合

答案查题题库