in order to
[观察]
1. He got up very early in order to / so as to catch the first bus.
2. In order to catch the first bus, he got up very early.
3. He works very hard in order to / so as to support his family.
4. Turn the volume down in order not to / so as not to wake the child.
[归纳] in order to 意为“为了……”，表示目的；在用法和意义上相当于so as to 结构，但是in order to结构可以用于句首、句中，而so as to多用于句中。其否定式分别为：in order not to 和so as not to。
[拓展] in order to和so as to在句中表示目的时，常可以转化成in order that或so that引导的目的状语从句。如:
We should work hard in order to / so as to pass the exam.
→ We should work hard in order that / so that we can pass the exam.
为了能通过考试，我们应该努力学习。
[小试] 翻译下面的句子。
1. He went there early so as to / in order to get a good seat.
He went there early so that / in order that he could get a good seat.
2. In order not to wake the baby we went in quietly.
Key:
1. 他去得早，以便找到个好座位。
2. 为了不惊醒小孩，我们轻轻地走了进去。
order的过去式 那么你知道order的过去式怎么写吗?下面是为你整理的order的过去式，希望大家喜欢!order的过去式过去式：orderedorder的过去式ordered造句1. He ordered them to stack up pillows behind his back.他命令他们把几个枕头叠放在自己的背后。 2. President Garcia has ordered an airlift of food, medicines and blankets.加西亚总统已经下令空运食品、药物和毛毯。 3. The president ordered a review of US economic aid to Jordan.总统下令对美国向约旦提供的经济援助进行审查。 4. The government ordered an independent inquiry into the affair.政府下令对该事件进行独立调查。 5. Felicity Maxwell stood by the bar and ordered a glass of wine.费利西蒂·马克斯韦尔站在吧台旁，要了一杯红酒。 6. He watched the barman prepare the beer he had ordered.他看着酒吧招待员备好他点的啤酒。 7. The colonel ordered, "I want two good engines down here asap."上校命令道：“尽快给我找两台性能好的发动机来。 8. Magistrates ordered his dog Samson to be put down immediately.治安官们勒令立即将他的狗萨姆森杀掉。 9. He was given a conditional discharge and ordered to pay compensation.他被有条件地释放了，被责令支付赔偿款。
感官动词和使役动词 默认分类2010-05-28 23:14:26 阅读46 评论0 字号：大中小订阅 使役动词，比如let make have就是3个比较重要的 have sb to do 没有这个用法的 只有have sb doing.听凭某人做某事 have sb do 让某人做某事 have sth done 让某事被完成（就是让别人做） 另外： 使役动词 1.使役动词是表示使、令、让、帮、叫等意义的不完全及物动词,主要有make(使,令), let(让), help(帮助), have(叫)等。 2.使役动词后接受词,再接原形不定词作受词补语。 He made me laugh. 他使我发笑。 I let him go. 我让他走开。 I helped him repair the car. 我帮他修理汽车。 Please have him come here. 请叫他到这里来。 3.使役动词还可以接过去分词作受词补语。 I have my hair cut every month. 我每个月理发。 4.使役动词的被动语态的受词补语用不定词,不用原形不定词。 (主)He made me laugh. 他使我笑了。 (被)I was made to laugh by him. 我被他逗笑了。 使役动词有以下用法： a. have somebody do sth让某人去做某事 ??i had him arrange for a car. b. have somebody doing sth.让某人持续做某事。 ??he had us laughing all through lunch. 注意：用于否定名时，表示“允许” i won't have you running around in the house. 我不允许你在家里到处乱跑。 ******** 小议“使役动词”的用法 1. have sb do 让某人干某事 e.g:What would you have me do? have sb/sth doing 让某人或某事处于某种状态，听任 e.g: I won't have women working in our company. The two cheats had the light burning all night long. have sth done 让别人干某事，遭受到 e.g:you 'd better have your teeth pulled out. He had his pocket picked. notes: "done"这个动作不是主语发出来的。 2.make sb do sth 让某人干某事 e.g:They made me repeat the story. What makes the grass grow?
The way 的用法 Ⅰ常见用法： 1)the way+ that 2)the way + in which（最为正式的用法） 3)the way + 省略（最为自然的用法） 举例：I like the way in which he talks. I like the way that he talks. I like the way he talks. Ⅱ习惯用法： 在当代美国英语中，the way用作为副词的对格，“the way+ 从句”实际上相当于一个状语从句来修饰整个句子。 1)The way =as I am talking to you just the way I’d talk to my own child. He did not do it the way his friends did. Most fruits are naturally sweet and we can eat them just the way they are—all we have to do is to clean and peel them. 2）The way= according to the way/ judging from the way The way you answer the question, you are an excellent student. The way most people look at you, you’d think trash man is a monster. 3）The way =how/ how much No one can imagine the way he missed her. 4）The way =because
in order to [观察] 1. He got up very early in order to / so as to catch the first bus. 2. In order to catch the first bus, he got up very early. 3. He works very hard in order to / so as to support his family. 4. Turn the volume down in order not to / so as not to wake the child. [归纳] in order to 意为“为了……”，表示目的；在用法和意义上相当于so as to 结构，但是in order to结构可以用于句首、句中，而so as to多用于句中。其否定式分别为：in order not to 和so as not to。 [拓展] in order to和so as to在句中表示目的时，常可以转化成in order that或so that引导的目的状语从句。如: We should work hard in order to / so as to pass the exam. → We should work hard in order that / so that we can pass the exam. 为了能通过考试，我们应该努力学习。 [小试] 翻译下面的句子。 1. He went there early so as to / in order to get a good seat. He went there early so that / in order that he could get a good seat. 2. In order not to wake the baby we went in quietly. Key: 1. 他去得早，以便找到个好座位。 2. 为了不惊醒小孩，我们轻轻地走了进去。
感官动词 1.see, hear, listen to, watch, notice等词，后接宾语，再接省略to的动词不定式或ing形式。前者表全过程，后者表正在进行。句中有频率词时，以上的词也常跟动词原形。 注释:省略to的动词不定式--to do是动词不定式，省略了to,剩下do，其形式和动词原形是一样的，但说法不同。 see sb do sth 看到某人做了某事 see sb doing sth 看到某人在做某事 hear sb do sth 听到某人做了某事 hear sb doing sth 听到某人在做某事 以此类推... I heard someone knocking at the door when I fell asleep. (我入睡时有人正敲门,强调当时正在敲门) I heard someone knock at the door three times. (听到有人敲门的全过程) I often watch my classmates play volleyball after school. (此处有频率词often) （了解）若以上词用于被动语态，须将省略的to还原： see sb do sth----sb be seen to do sth hear sb do sth----sb be seen to do sth 以此类推... We saw him go into the restaurant. → He was seen to go into the restaurant. I hear the boy cry every day. → The boy is heard to cry every day. 2.感官动词look, sound, smell, taste, feel可当系动词，后接形容词。 He looks angry. His explanation sounds reasonable. The cakes smell nice.
The way的用法及其含义（二） 二、the way在句中的语法作用 the way在句中可以作主语、宾语或表语： 1.作主语 The way you are doing it is completely crazy.你这个干法简直发疯。 The way she puts on that accent really irritates me. 她故意操那种口音的样子实在令我恼火。The way she behaved towards him was utterly ruthless. 她对待他真是无情至极。 Words are important, but the way a person stands, folds his or her arms or moves his or her hands can also give us information about his or her feelings. 言语固然重要,但人的站姿,抱臂的方式和手势也回告诉我们他(她)的情感。 2.作宾语 I hate the way she stared at me.我讨厌她盯我看的样子。 We like the way that her hair hangs down.我们喜欢她的头发笔直地垂下来。 You could tell she was foreign by the way she was dressed. 从她的穿著就可以看出她是外国人。 She could not hide her amusement at the way he was dancing. 她见他跳舞的姿势，忍俊不禁。 3.作表语 This is the way the accident happened.这就是事故如何发生的。 Believe it or not, that's the way it is. 信不信由你, 反正事情就是这样。 That's the way I look at it, too. 我也是这么想。 That was the way minority nationalities were treated in old China. 那就是少数民族在旧中
英语中感官动词的用法 一、感官动词 1、感官动词(及物动词)有：see/notice/look at/watch/observe/listen to/hear/feel(Vt)/taste(Vt)/smell(Vt) 2、连缀动词(含感官不及物动词) be/get/become/feel/look/sound/smell/taste/keep/stay/seem/ appear/grow/turn/prove/remain/go/run 二、具体用法： 1、see, hear, smell, taste, feel,这五个动词均可作连系动词，后面接形容词作表语，说明主语所处的状态。其意思分别为"看/听/闻/尝/摸起来……"。除look之外，其它几个动词的主语往往是物，而不是人。 例如：These flowers smell very sweet.这些花闻起来很香。 The tomatoes feel very soft.这些西红柿摸起来很软。 2、这些动词后面也可接介词like短语，like后面常用名词。 例如：Her idea sounds like fun.她的主意听起来很有趣。 3、这五个感官动词也可作实义动词,除look(当"看起来……"讲时)只能作不及物动词外,其余四个既可作及物动词也可作不及物动词,此时作为实义动词讲时其主语一般为人。 例如:She smelt the meat.她闻了闻那块肉。 I felt in my pocket for cigarettes.我用手在口袋里摸香烟。 4、taste, smell作不及物动词时,可用于"t aste / smell + of +名词"结构,意为"有……味道/气味"。 例如:The air in the room smells of earth.房间里的空气有股泥土味。 5、它们(sound除外)可以直接作名词,与have或take构成短语。 例如：May I have a taste of the mooncakes?我可以尝一口这月饼吗？taste有品位、味道的意思。 例如：I don’t like the taste of the garlic.我不喜欢大蒜的味道。 She dresses in poor taste.她穿着没有品位。 look有外观，特色的意思，例：The place has a European look.此地具有欧洲特色。 feel有感觉，感受的意思，watch有手表，观察的意思。例：My watch is expensive.我的手表很贵。 6、其中look, sound, feel还能构成"look / sound / feel + as if +从句"结构，意为"看起来/听起来/感觉好像……"。 例如：It looks as if our class is going to win.看来我们班好像要获胜了。 7、感官动词+do与+doing的区别： see, watch, observe, notice, look at, hear, listen to, smell, taste, feel + do表示动作的完整性，真实性；+doing 表示动作的连续性，进行性。 I saw him work in the garden yesterday.昨天我看见他在花园里干活了。(强调"我看见了"
定冠词the的用法： 定冠词the与指示代词this ,that同源,有“那(这)个”的意思,但较弱,可以和一个名词连用,来表示某个或某些特定的人或东西. (1)特指双方都明白的人或物 Take the medicine.把药吃了. (2)上文提到过的人或事 He bought a house.他买了幢房子. I've been to the house.我去过那幢房子. (3)指世界上独一无二的事物 the sun ,the sky ,the moon, the earth (4)单数名词连用表示一类事物 the dollar 美元 the fox 狐狸 或与形容词或分词连用,表示一类人 the rich 富人 the living 生者 (5)用在序数词和形容词最高级,及形容词等前面 Where do you live?你住在哪? I live on the second floor.我住在二楼. That's the very thing I've been looking for.那正是我要找的东西. (6)与复数名词连用,指整个群体 They are the teachers of this school.(指全体教师) They are teachers of this school.(指部分教师) (7)表示所有,相当于物主代词,用在表示身体部位的名词前 She caught me by the arm.她抓住了我的手臂. (8)用在某些有普通名词构成的国家名称,机关团体,阶级等专有名词前 the People's Republic of China 中华人民共和国 the United States 美国 (9)用在表示乐器的名词前 She plays the piano.她会弹钢琴. (10)用在姓氏的复数名词之前,表示一家人 the Greens 格林一家人(或格林夫妇) (11)用在惯用语中 in the day, in the morning... the day before yesterday, the next morning... in the sky... in the dark... in the end... on the whole, by the way...
order by 、group by 、having的用法区别 order by 从英文里理解就是行的排序方式，默认的为升序。order by 后面必须列出排序的字段名，可以是多个字段名。 group by 从英文里理解就是分组。必须有“聚合函数”来配合才能使用，使用时至少需要一个分组标志字段。 什么是“聚合函数”？ 像sum()、count()、avg()等都是“聚合函数” 使用group by 的目的就是要将数据分类汇总。 一般如： select 单位名称,count(职工id),sum(职工工资) form [某表] group by 单位名称 这样的运行结果就是以“单位名称”为分类标志统计各单位的职工人数和工资总额。 在sql命令格式使用的先后顺序上，group by 先于order by。select 命令的标准格式如下： SELECT select_list [ INTO new_table ] FROM table_source [ WHERE search_condition ] [ GROUP BY group_by_expression ] [ HA VING search_condition ] 1. GROUP BY 是分组查询, 一般GROUP BY 是和聚合函数配合使
用 group by 有一个原则,就是select 后面的所有列中,没有使用聚合函数的列,必须出现在group by 后面（重要） 例如,有如下数据库表： A B 1 abc 1 bcd 1 asdfg 如果有如下查询语句（该语句是错误的，原因见前面的原则）select A,B from table group by A 该查询语句的意图是想得到如下结果(当然只是一相情愿) A B abc 1 bcd asdfg 右边3条如何变成一条,所以需要用到聚合函数，如下(下面是正确的写法): select A,count(B) as 数量from table group by A 这样的结果就是 A 数量 1 3 2. Having
1.感官动词用法之一：see, hear, listen to, watch, notice等词，后接宾语，再接动词原形或ing形式。前者表全过程，后者表正在进行。句中有频率词时，以上的词也常跟动词原形。 I heard someone knocking at the door when I fell asleep. (我入睡时有人正敲门) I heard someone knock at the door three times. (听的是全过程) I often watch my classmates play volleyball after school.(此处有频率词often) 若以上词用于被动语态，后面原有动词原形改为带to不定式： We saw him go into the restaurant. →He was seen to go into the restaurant. I hear the boy cry every day. →The boy is heard to cry every day. 2.感官动词用法之二：look, sound, smell, taste, feel可当系动词，后接形容词： He looks angry. It sounds good. The flowers smell beautiful. The sweets taste sweet. The silk feels soft. I felt tired. They all looked tired. 这些动词都不用于被动语态。如：The sweets are tasted sweet.是个病句。注意：如果加介词like,则后不可接形容词，而接名词或代词：
“tｈｅwａｙ+从句”结构的意义及用法 首先让我们来看下面这个句子: Ｒead the foｌloｗｉnｇpassagｅａnd talkａbout ｉt wi ｔh your classmaｔes．Try tｏｔeｌl whaｔyｏu thiｎk ｏf Tom aｎd ｏｆｔhe ｗay the chiｌｄrenｔrｅated ｈim. 在这个句子中，ｔhe waｙ是先行词,后面是省略了关系副词that或in whｉch的定语从句。 下面我们将叙述“the ｗaｙ+从句”结构的用法。 1.tｈe wａy之后，引导定语从句的关系词是tｈat而不是hoｗ,因此，<<现代英语惯用法词典＞＞中所给出的下面两个句子是错误的：Ｔhｉs is ｔｈeｗayｈowｉtｈａppened. This is the way how he ａlwａｙs treats me. 2．在正式语体中,thaｔ可被in which所代替;在非正式语体中，ｔhat则往往省略。由此我们得到theｗay后接定语从句时的三种模式：1) tｈe ｗaｙ＋ｔhａt-从句２）the way +ｉn whiｃh－从句3) the ｗay +从句 例如：Ｔｈe way(in whiｃh ，thａt) ｔhｅｓｅｃomｒade ｓloｏｋａｔｐrobｌems is wrong．这些同志看问题的方法
不对。 Ｔｈｅｗａy(that ,ｉn ｗhiｃh)yoｕ’ｒe doinｇit is comple ｔeｌy crａzy.你这么个干法,简直发疯。 Wｅａdmiｒｅd him for thｅｗay ｉｎｗhｉch he fａｃeｓdiｆficultieｓ． Waｌlａｃe ａｎd Ｄarwiｎｇreed ｏn the way ｉｎwhi ｃh ｄｉfｆｅrｅnt forms ｏf life had ｂegｕn.华莱士和达尔文对不同类型的生物是如何起源的持相同的观点。 Thｉs is ｔｈe ｗaｙ（tｈａｔ) hｅdｉd it. I lｉkeｄｔhe waｙ(ｔhat) ｓｈeｏｒganized ｔhe ｍeetｉng． 3.theｗay(tｈat)有时可以与hｏw(作“如何”解）通用。例如： That’s tｈe ｗaｙ(tｈaｔ) shｅspoke. = Tｈat’s how shｅspoke.
in order to可以用在句首或句末，但so as to只能用在句末。 如： He got up very early in order to/so as to catch the first bus. In order to catch the first bus,he got up very early.（此时不能用so as to）so as to 和in order to的汉语意思应该是一样的“为的是，为了”。它们的英语功能也是一样的，都可以用来引导目的状语。它们的不同之处就在于so as to 不能用于句子的开头，在句子开头只能用in order to. 另外， 1.in order to 一般用in order that加从句来替换；而so as to 一般用so that加从句来替换。in order that 可以在句首，so that和so as to 一样不能在句首。 2.当这两个短语后的不定式动词的逻辑主语和句子的主语一致时，“in order to , so as to +不定式”可以简化为“不定式” In order to get to school on time,he got up earlier.这个句子可以表达为下列几种方式：In order that he could get to school on time,.... He got up earlier in order to get to school on time. He got up earlier in order that he could get to school on time. He got up earlier so as to get to school on time. He got up earlier so that he could get to school on time. To get to school on time, he got up earlier. （这种不定式有时可以表示目的以外的状语） 1.so that表目的。在非正式语体中，so可以代替so that,引出目的状语从句。例如：He is going to the lecture early so (that) he will get a good seat. 2.so that表结果。so是so that 的省略形式，引导结果状语从句，主要用在口语中。 3.in order that与虚拟式 They removed the prisoner in order that he not disturb the procceedings any f urther.句子中he not disturb符合语法吗？是否应该改成he does not disturb? 在正式语体中，in order that引导的状语从句有时也采用现在虚拟式，上句中的he not disturb也可以用he should not disturb来替换。 4.in order that与情态动词 在in order that从句中可以使用can,could,may,might,should,would等情态动词。 5.in order to in order to+动词不定式用来表目的，它所引导的是目的状语。 6.so that与in order that的关系 in order that用于相当正式的语体中，表示经过精心策划的目的，有时可与so t hat互换。
表示“方式”、“方法”，注意以下用法： 1.表示用某种方法或按某种方式，通常用介词in(此介词有时可省略)。如： Do it (in) your own way. 按你自己的方法做吧。 Please do not talk (in) that way. 请不要那样说。 2.表示做某事的方式或方法，其后可接不定式或of doing sth。 如： It’s the best way of studying [to study] English. 这是学习英语的最好方法。 There are different ways to do [of doing] it. 做这事有不同的办法。 3.其后通常可直接跟一个定语从句(不用任何引导词)，也可跟由that 或in which 引导的定语从句，但是其后的从句不能由how 来引导。如： 我不喜欢他说话的态度。 正：I don’t like the way he spoke. 正：I don’t like the way that he spoke. 正：I don’t like the way in which he spoke. 误：I don’t like the way how he spoke. 4.注意以下各句the way 的用法： That’s the way (=how) he spoke. 那就是他说话的方式。 Nobody else loves you the way(=as) I do. 没有人像我这样爱你。 The way (=According as) you are studying now, you won’tmake much progress. 根据你现在学习情况来看，你不会有多大的进步。 2007年陕西省高考英语中有这样一道单项填空题： ——I think he is taking an active part insocial work. ——I agree with you_____. A、in a way B、on the way C、by the way D、in the way 此题答案选A。要想弄清为什么选A，而不选其他几项，则要弄清选项中含way的四个短语的不同意义和用法，下面我们就对此作一归纳和小结。 一、in a way的用法 表示：在一定程度上，从某方面说。如： In a way he was right.在某种程度上他是对的。注：in a way也可说成in one way。 二、on the way的用法 1、表示：即将来(去)，就要来(去)。如： Spring is on the way.春天快到了。 I'd better be on my way soon.我最好还是快点儿走。 Radio forecasts said a sixth-grade wind was on the way.无线电预报说将有六级大风。 2、表示：在路上，在行进中。如： He stopped for breakfast on the way.他中途停下吃早点。 We had some good laughs on the way.我们在路上好好笑了一阵子。 3、表示：(婴儿)尚未出生。如： She has two children with another one on the way.她有两个孩子，现在还怀着一个。 She's got five children，and another one is on the way.她已经有5个孩子了，另一个又快生了。 三、by the way的用法
so that和in order that I hurried _____ I wouldn't be late for class.这里为什么用so that不用in order that？麻烦详细解析，谢谢！ 你好，这里要用so that因为固定词组是in order to，如果用in order that本身词组有问题了，可以查一查词组字典所以可以说I hurried in order to not be late for class，这样才对。你只要记牢so that后面跟的是一个长句子，而in order to 后面跟的是一个短语，这道题很明显空格后面是一个长句子，自然要用so that 了 2、so that:有两种用法——①【为的是，以便】，引导目的状语从句，此时意义上等同于in order that。但是，区别在于【in order that】可以【放在句首】，而【so that】则【不能放在句首】。例如：We started early 【so that/in order that 】we could get the first bus.【In order that】the workers can work hard,they have been given higher bonus.2.【以至于;结果】，引导【结果状语从句】，一般【用逗号与主句隔开】。例如：They ran to the station, 【so that】they caught the train for Beijing in time. 3、so...that,【以至于;结果】，引导【结果状语从句】。例如：Li Lei studied【so 】hard 【that】he was admitted into Fudan University last year. 4、in order to,so as to 这两个短语都是【以便；为了】，表示目的，但是，他们都是【不定式】形式，不能引导从句。还有，在位置上，【so as to】【不能位于句首】；而【in order to】则【可以放在句首】。例如：A large number of college students prefer to working 【in order to/so as to】make money for their education. 【In order to】help great numbers of senior students realise their dreams of going to college, our government have taken lots of measures . so that、in order that、so as 、in order to 各自的用途与它们之间的区别 so that 是以至于的意思，他和so ...that也不一样，（省略出是个形容词）1.so that表目的。在非正式语体中，so可以代替so that,引出目的状语从句。例如：He is going to the lecture early so (that) he will get a good seat. 2.so that表结果。so是so that 的省略形式，引导结果状语从句，主要用在口语中。 3.in order that与虚拟式They removed the prisoner in order that he not disturb the procceedings any further.句子中he not disturb符合语法吗？是否应该改成he does not disturb? 在正式语体中，in order that引导的状语从句有时也采用现在虚拟式，上句中的he not disturb也可以用he should not disturb来替换。4.in order that与情态动词在in order that从句中可以使用can,could,may,might,should,would等情态动词。5.in order to in order to+动词不定式用来表目的，它所引导的是目的状语。6.so that与in order that的关系in order that 用于相当正式的语体中，表示经过精心策划的目的，有时可与so that互换。7。so as和to 搭配。构成固定搭配so as to ，它和in order to 的意思是一样的，没有什么具体的区别 so that与so ... that ...的用法在近几年来全国各省市的中考试题中出现率较高，一直是历年来中考试题的重要考点。下面结合近几年来的中考试题，将so that与so ... that ... 的用法归纳如下： 一、so that引导目的状语从句时，表示“以便；为了”，从句中常使用can /could /may /might /will /would /should等情态动词或助动词；引导结果状语从句时，从句中一般不用can和may 等词，在so that前可以用逗号，意思是“因此;所以”。如： 1. The little boy saved every coin_________ __________he could buy his mother a present on Mother's day.(用所给的短语填空，每个短语只能用一次)(2003大连市) (答案为so that。)
感官动词的概念和相关考点 1、什么是感官动词？ 听觉：listen to、hear 视觉：look at、seem、watch 嗅觉：smell 触觉：feel、touch 味觉：taste 2、感官动词如何正确使用？ Tom drove his car away. →I saw him drive away. (全过程) 用法一：somebody did sth + I saw this I saw somebody do something. Tom was waiting for the bus. →I saw Tom waiting for the bus. (看不到全过程) 用法二：somebody was doing sth + I saw this I saw somebody doing something 练习： 一、句子翻译 1. I didn,t hear you come in. 2. I suddenly felt sth touch me on the shoulder. 3. I could hear it raining. 4. Listen to the birds singing. 5. Can you smell sth burning? 6. I found Sue in my room reading my letters. 二、灵活运用 1. I saw Ann waiting for the bus. 2. I saw Dave and Helen playing tenins. 3. I saw Clair having her meal. 三、选择最佳选项 1. Did anybody see the accident (happen/happening)? 2. We listen to the old man (tell/telling) his story from beginning to the end. 3. Listen! Can you hear a baby (cry/crying)? 4.—Why did you turn around suddenly? — I heard someone (call/calling) my name. 5. We watched the two men (open/opening) a window and (climb/climbing) through it into house. 6. When we got there, we found our cat (sleep/sleeping) on the table. 四、感官动词的被动语态 Oh，the milk is tasted strange.
SQL AVG 函数
定义和用法
AVG 函数返回数值列的平均值。NULL 值不包括在计算中。
SQL AVG() 语法
SELECT AVG(column_name) FROM table_name
SQL AVG() 实例
我们拥有下面这个 "Orders" 表： O_Id 1 2 3 4 5 6 OrderDate 2008/12/29 2008/11/23 2008/10/05 2008/09/28 2008/08/06 2008/07/21 OrderPrice 1000 1600 700 300 2000 100 Customer Bush Carter Bush Bush Adams Carter
现在，我们希望计算 "OrderPrice" 字段的平均值。 我们使用如下 SQL 语句：
SELECT AVG(OrderPrice) AS OrderAverage FROM Orders
结果集类似这样： OrderAverage 950
现在，我们希望找到 OrderPrice 值高于 OrderPrice 平均值的客户。 我们使用如下 SQL 语句：
SELECT Customer FROM Orders WHERE OrderPrice>(SELECT AVG(OrderPrice) FROM Orders)
结果集类似这样： Customer Bush Carter
SQL COUNT() 函数
COUNT() 函数返回匹配指定条件的行数。
SQL COUNT() 语法
SQL COUNT(column_name) 语法 COUNT(column_name) 函数返回指定列的值的数目（NULL 不计入） ：
SELECT COUNT(column_name) FROM table_name
SQL COUNT(*) 语法 COUNT(*) 函数返回表中的记录数：
SELECT COUNT(*) FROM table_name
我们学过了五个与人的感觉有关的动词，它们是look，sound，smel l，taste，feel，我们可称之为“感官”动词。它们的用法有着许多相同点，但也有不同之处，现就此作一小结。 一、这五个动词均可作连系动词，后面接形容词作表语，说明主语所处的状态。其意思分别为“看/听/闻/尝/摸起来……”。除loo k之外，其它几个动词的主语往往是物，而不是人。例如：These flowers smell very sweet. 这些花闻起来很香。 The tomatoes feel very soft. 这些西红柿摸起来很软。 The music sounds beautiful. 二、这些动词后面也可接介词like短语，like后面常用名词。例如： Her idea sounds like fun. 她的主意听起来很有趣。 He looks like his father. 三、这五个感官动词也可作实义动词，除look（当“看起来……”讲时）只能作不及物动词外，其余四个既可作及物动词也可作不及物动词，其主语通常是人。例如： She smelt the meat. 她闻了闻那块肉。
I felt in my pocket for cigarettes. 我用手在口袋里摸香烟。 He tasted the soup and added some salt. Miss Wang asked us to look at the blackboard. 四、taste，smell作不及物动词时，可用于“taste / smell + of + 名词”结构，意为“有……味道 / 气味”。例如： The air in the room smells of earth. 房间里的空气有股泥土味。 The bread taste of sugar. 五、它们（sound除外）可以直接作名词，与have或take构成短语。例如： May I have a taste of the mooncakes？我可以尝一口这月饼吗？ May I have a look at your photo? 六、其中look，sound，feel还能构成“look / sound / feel + as if +从句”结构，意为“看起来/听起来/ 感觉好像……”。例如：