Lesson2 练习及参考答案
- 格式:doc
- 大小:217.00 KB
- 文档页数:4
新概念英语二 Lesson 2Lesson 2 Breakfast or lunch?First listen and then answer the question. 听录音,然后回答以下问题。
Why was the writer's aunt surprised?It was Sunday. I never get up early on Sundays. I sometimes stay in bed until lunch time. Last Sunday I got up very late. I looked out of the window. It was dark outside. ‘What a day!' I thought.‘It's raining again.' Just then, the telephone rang. It was my aunt Lucy. ‘I've just arrived by train,' she said. ‘I'm coming to see you.'‘But I'm still having breakfast,' I said.‘What are you doing?' she asked.‘I'm having breakfast,' I repeated.‘Dear me,' she said. ‘Do you always get up so late? It's one o'clock!'New words and expressions 生词和短语until prep. 直到 outside adv. 外面ring v. (铃、电话等)响 aunt n. 姑,姨,婶,舅母repeat v. 重复Note on the text 课文注释1 on Sundays, 指每个星期日。
冀教版(一起)六年级上册《Lesson 2 Turn off the Computer》同步练习卷一、翻译.1. (1)歌曲________(2)电脑________(3)把…关小________(4)晚的,迟的________二、根据要求写出单词.(1)on(反义词)________(2)ear(复数形式)________(3)up(反义词)________(4)wrong(反义词)________(5)turn (﹣ing 形式)________(6)do not (缩写形式)________三、英汉翻译.这首歌太棒了!________Jack! Turn down your computer, please.________Time to go to bed.________请把你的电脑关掉.________四、选择题.Time _______go to bed.()A.isB.toC.didD.doesIt's too loud. Please turn it _____.()A.onB.downC.upD.inIt's time to go to bed. Turn ________ your computer, please.()A.onB.inC.offD.downSome people play computer games all night long and they ________ ill.()A.fallB.fellC.feelD.falls五、连线题.参考答案与试题解析冀教版(一起)六年级上册《Lesson 2 Turn off the Computer》同步练习卷一、翻译.1.【答案】song,computer,turn down,late【考点】翻译能力单词、词组Fun for You and Me: Turn off the Compute【解析】(1)歌曲song;(2)电脑computer;(3)把…关小turn down;(4)晚的,迟的late.【解答】(1)song."歌曲"译为"song".(2)computer."电脑"译为"computer".(3)turn down."把…关小"译为"turn down".(4)late."晚的,迟的"译为"late".二、根据要求写出单词.【答案】under,ears,down,right,turning,don't【考点】反义词、对应词全写和缩写可数名词及其单复数物主代词Fun for You and Me: Turn off the Compute【解析】on在……上,under在……下ear耳朵up向上,down向下turn转方向do not不要【解答】(1)由题,on意为"在……上",其反义词应意为"在……下",故答:under.(2)ear其复数形式符合一般名词变化规则,直接加"s",故答:ears.(3)由题,up意为"向上",其反义词应意为"向下",故答:down.(4)由题,wrong意为"错误的",其反义词应意为"正确的",故答:right.(5)由题,turn符合一般动词ing形式的变化规律,直接加ing即可,故答:turning.(6)由题,do not的缩写形式为"don't",故答:don't.三、英汉翻译.【答案】This song sounds very good!【考点】汉译英Fun for You and Me: Turn off the Compute【解析】这首歌太棒了!This song sounds very good!【解答】该题考查汉译英.根据给出的汉语可知该句子是一个系表结构.一般现在时,主语是"这首歌",This song;听起来是"sound",主语是单数,故谓语用三单形式"sounds";太棒了是"very good";故答案是:This song sounds very good!【答案】杰克!请把你电脑声音关小.【考点】英译汉Fun for You and Me: Turn off the Compute【解析】杰克!请把你电脑声音关小.【解答】本题主要考查英译汉.Jack杰克! Turn down关小,your computer你的电脑,please 请.结合整句与中文的表达习惯.故翻译为:杰克!请把你电脑声音关小.【答案】是时候去睡觉了.【考点】英译汉Fun for You and Me: Turn off the Compute【解析】是时候去睡觉了.【解答】本题主要考查英译汉.Time to do是时候做…了,go to bed睡觉.结合整句与中文的表达习惯.故翻译为:是时候去睡觉了.【答案】Turn off your computer,please.【考点】汉译英Fun for You and Me: Turn off the Compute【解析】Turn off your computer,please.请把你的电脑关掉.该题考查汉译英.根据给出的汉语可知是一个祈使句以动词原形开头."把…关掉"是"turn off","你的电脑"是"your computer","请"是"please"习惯放在句尾.故答案是:Turn off your computer,please.四、选择题.【答案】B【考点】动词不定式Fun for You and Me: Turn off the Compute【解析】该睡觉了.【解答】本题考查动词不定式的用法.It's time to do sth,表示该做某事了,根据Time_______go to bed,这里前面省略了It's.故选:B.【答案】B【考点】介词Fun for You and Me: Turn off the Compute【解析】声音太大了,请把它关小.【解答】考查介词的辨析.根据It's too loud,可知声音太大了,所以应该是调小声音,用turn down.故选:B.【答案】C【考点】介词Fun for You and Me: Turn off the Compute【解析】该睡觉了,关上你的电脑.【解答】该题考查介词的辨析.根据"It's time to go to bed."可知后面是"关电脑",关上是"turn off".故选:C.【答案】A【考点】动词原形Fun for You and Me: Turn off the Compute有些人整夜玩电脑游戏,生病了.【解答】本题考查动词原形.根据Some people play computer games all night long and they ill,可知句子叙述一件事实,时态用一般现在时,主语是复数.故选:A.五、连线题.【答案】C,B,E,F,A,D【考点】固定搭配Fun for You and Me: Turn off the Compute【解析】(1)你有一只钢笔吗?是的,我有.(2)请把你的电脑关小一点.对不起,我会的.(3)丹尼,该睡觉了.好的,我马上去睡觉.(4)你能把音量调大吗?不,我不能.(5)你为什么不去上学?因为我生病了.(6)你多久踢一次足球?一周一次.【解答】(1)考查句子的理解和上下文的联系,对于"Do you have a pen?"的肯定回答应是:Yes, I do.结合选项可知C符合题意.(2)考查句子的理解和上下文的联系,"Turn down your computer, please"为祈使句,答语应表示"对不起",结合选项可知B符合题意.(3)考查句子的理解和上下文的联系;"Danny, it's time to go to bed"是提出的好建议,答语应表示同意和支持,"Ok, I'll go to bed right away".故选E.(4)考查句子的理解和上下文的联系;对于"Can you turn it up?"的回答应是No, I can't或Yes,I can,结合选项可知,F符合题意.(5)考查句子的理解和上下文的联系;"Why don't you go to school?"是询问原因,答语应是"Because…",对应选项A.(6)考查句子的理解和上下文的联系;"How often do you play football?"是询问频率,答语应为:Once a week.故选D.。
英语初级听力参考答案lesson2英语初级听力参考答案Lesson 2在英语初级听力课程中,Lesson 2 通常涵盖了一些基础的听力练习,目的是帮助学生提高对英语口语的理解能力。
以下是一些可能的听力练习题目及其参考答案。
练习一:听对话,选择正确答案1. 听对话,对话中的人物在谈论什么?A. 天气预报B. 购物清单C. 旅行计划D. 工作安排答案:C2. 听对话,对话中的人物正在做什么?A. 在图书馆学习B. 在餐厅点餐C. 在公园散步D. 在家里看电视答案:B3. 听对话,对话中的人物提到了哪个国家?A. 美国B. 英国C. 澳大利亚D. 加拿大答案:A练习二:听短文,回答问题1. 短文中提到的主要人物是谁?A. 一位老师B. 一位学生C. 一位医生D. 一位警察答案:B2. 短文中提到的活动是什么?A. 学校运动会B. 学校音乐会C. 学校戏剧表演D. 学校科学展览答案:A3. 短文中提到的日期是什么时候?A. 星期一B. 星期三C. 星期五D. 星期天答案:C练习三:听指令,执行任务1. 听指令,你需要做什么?- 打开窗户。
- 关闭电视。
- 拿起电话。
- 穿上外套。
答案:打开窗户。
2. 听指令,你需要去哪里?- 图书馆。
- 超市。
- 邮局。
- 银行。
答案:超市。
3. 听指令,你需要带什么?- 一本书。
- 一把伞。
- 一张地图。
- 一个钱包。
答案:一把伞。
练习四:听歌曲,填空1. The song is about _______.A. loveB. friendshipC. familyD. school答案:A2. The singer mentions _______ as a symbol of happiness.A. a smileB. a giftC. a songD. a hug答案:C3. In the song, the singer says that _______ can make youfeel better.A. cryingB. laughingC. workingD. sleeping答案:B练习五:听对话,判断正误1. The man is going to the beach this weekend. (True / False)答案:True2. The woman has never been to the museum. (True / False)答案:False3. They are discussing a new movie. (True / False)答案:True请注意,这些参考答案仅供学习和练习使用。
Lesson 2 How can we do? 第二课时习题一、判断读音是否一致。
( )1. change knowledge( )2. cheap watch( )3. short catch( )4. lunch match( )5. age bridge二、选择题。
( )1. ______ can we draw a line?A. HowB. WhyC. Who( )2. We can draw a line ______ a ruler.A. atB. byC. with( )3. Don’t be afraid ______ the new words.A. atB. ofC. to( )4. This is the ______ I wash my face.A. wayB. methodC. road( )5. Can you help me? -No, I ______A. canB. can’tC. don’t三、匹配句子。
( ) 1. What are you doing?( ) 2. Is he wearing a shirt?( ) 3. How can we draw a circle?( ) 4. Can you give it to me?( ) 5. What do you want?A.I want a hat.B. Yes, he is.C. I’m reading.D. Here you are.E. We can draw it with a card.四、阅读理解。
A: Zhang Peng. Let's go to the park this morning.B: Great! How do we go to the park?A: It's easy to come to my home by bike, then we can go there by bus.B: OK! Where is your home?A: Do you know the post office near the subway? I live in the apartment building.B: I see, goodbye! John!A: Goodbye!1. Where is John's home?___________________________________________________________2. How do they go to the park?___________________________________________________________3. How does Zhang Peng go to John's home?___________________________________________________________4. Does John live in the apartment building?___________________________________________________________五、写作。
新概念英语的参考答案新概念英语是一套广泛使用的英语教材,它以其系统性、实用性和趣味性而受到广大英语学习者的欢迎。
这套教材分为四个级别,分别对应不同的学习阶段和目标。
参考答案通常包括课文的翻译、练习题的答案以及一些语言点的解析。
以下是新概念英语参考答案的示例内容。
新概念英语参考答案第一册:基础英语Lesson 1: Excuse me!- 课文翻译:对不起!- 练习题答案:- 1. Excuse me, is this your handbag?- 2. Pardon?- 3. Yes, it is.- 4. Thank you very much.Lesson 2: Is this your...?- 课文翻译:这是你的...吗?- 练习题答案:- 1. Is this your pen?- 2. Yes, it is.- 3. Is that your coat?- 4. No, it isn't.第二册:实践与进步Lesson 1: A private conversation- 课文翻译:私人对话- 练习题答案:- 1. The man is reading a book.- 2. The woman is not listening to the man. - 3. The man is angry.Lesson 2: Breakfast or lunch?- 课文翻译:早餐还是午餐?- 练习题答案:- 1. The man is having lunch.- 2. The woman is having breakfast.- 3. The man is surprised.第三册:培养技能Lesson 1: A Puma at Large- 课文翻译:一只在逃的美洲豹- 练习题答案:- 1. A puma is at large.- 2. The puma was spotted in the area.- 3. The puma has not been caught.Lesson 2: Thirteen equals one- 课文翻译:十三等于一- 练习题答案:- 1. The writer's car has broken down.- 2. The writer is waiting for a bus.- 3. The writer has had thirteen flat tires.第四册:流利英语Lesson 1: Finding Fossils- 课文翻译:发现化石- 练习题答案:- 1. The writer and his wife are on a holiday.- 2. They found a fossil.- 3. The fossil is a giant tooth.Lesson 2: Spare that Spider- 课文翻译:别伤害那只蜘蛛- 练习题答案:- 1. The writer's friend is afraid of spiders.- 2. The spider is useful.- 3. The writer's friend will not kill the spider. 语言点解析- Past Simple: 表示过去发生的动作或状态。
Unit 1 Lesson 2 A Visit to the DentistⅠ.根据句意,从下面方框中选择适当的单词,并用其正确形式填空。
toothache German refuse fortunately headset1. I gave Ann a pretty present on her birthday, but she . Why?2. Simon can’t speak , but he likes songs very much.3. , we took a taxi, and we didn’t miss the train.4. I can’t eat, because I have a bad .5. Mr. Zhang told us to use our when listening to music. Ⅱ.根据汉语意思完成下列句子。
6. 我小的时候害怕晚上一个人回家。
When I was young, I home alone at night.7. 张涛昨天上午去看牙医了。
Zhang Tao yesterday morning. 8. 那天下雪了,所以我们别无选择只能放弃野营。
It snowed that day, so we to give up camping.9. 对不起,我马上把车挪开。
Sorry. I will move my car .10. 这个男孩对爬山很感兴趣。
The boy shows mountains.Ⅲ.为下面的问句选择适当的答语。
( )11. How long have you been here in the village?( )12. What’s wrong, Tony?( )13. What would you like to have?( )14. Need I finish the paper today?( )15. What did Miss Sun tell you?A. I’d like some dumplings.B. I’ve got a terrible pain in my leg.C. I’ve been here since 2010.D. She told me not to be late tomorrow.E. Yes, you must.Key:1. refused2. German; German3. Fortunately4. toothache5. headsets6. was afraid of going / was scared to go7. went to the dentist8. had no choice but9. right away10. great interest in climbing11-15 CBAED。
Lesson Two[hænz]ˈkrɪstʃən][ˈændəsən] [oʊn][ˈfɛri tel]Hans Christian Andersen’s Own Fairy Tale (I)[ˈdɑnəld] [luˈiz]Donald and Louise Peattie第2课汉斯·克里斯琴·安徒生自己的童话(1)唐纳德·皮蒂和路易丝·皮蒂[əˈpɒn] ['denmɑ:rk]1 Once upon a time there was a poor boy who lived in Denmark. His father, a shoemaker, had died, and his mother had married again.1从前,在丹麦有一个可怜的小男孩。
他的父亲是一名鞋匠,已经去世,而他的母亲改了嫁。
once upon a time 很久以前2 One day the boy went to ask a favor of the Prince of Denmark. When the Prince asked him what he wanted,ˈpoʊətri] ['θɪətə]the boy said, “I want to write plays in poetry and to act at the Royal Theater.”The Prince looked at the boy,atˈsɛnsəbəl]his big hands and feet, at his big nose and large serious eyes, and gave a sensible answer. “It is one thing to act in plays, another to write them. I tell you this for your own good; learn a useful trade like shoemaking. “2一天,这个男孩去向丹麦王子请求帮助。
牛津译林版英语预备课程Starter Lesson 2 A happy family同步练习卷一、根据汉语提示填空(共4 分)1.There are two children and ten ________ (妇女) on the bus.【答案】women【详解】句意:公共汽车上有两个孩子和十个女人。
由空格前数词“ten”可知,空格处用名词复数,woman“妇女”,复数是women。
故填women。
lie’s sister is 23 years old. She is a ________ (护士).【答案】nurse【详解】句意:米莉的姐姐23岁。
她是一名护士。
nurse“护士”,可数名词。
a后面要用可数名词单数。
故填nurse。
二、用所给单词的正确形式填空(共2 分)3.My ________ (伯母) likes me very much.【答案】aunt【详解】句意:我伯母非常喜欢我。
“伯母”aunt,“likes”是第三人称单数形式,可知主语为三单。
故填aunt。
三、根据汉语提示填空(共10 分)4.Jack has a book in his hand and he looks very ________ (高兴的).【答案】happy【详解】句意:杰克手里拿着一本书,他看起来很开心。
空格处作表语,用形容词,happy“高兴的”符合题意。
故填happy。
5.My ________ (叔叔) is an English teacher. He is 40 years old now.【答案】uncle【详解】句意:我叔叔是一名英语老师。
他现在40岁了。
uncle“叔叔”,根据is可知,此空应填单数名词,故填uncle。
6.My cousin is a ________ (医生) and he works very hard.【答案】doctor【详解】句意:我的表弟是一名医生,他工作很努力。
人教(精通)英语六年级上册Unit 1 Lesson 2同步练习卷1.选出下列单词的正确汉语意思。
()(1)over A.结束 B.开始()(2)dinner A.晚餐 B. 午餐()(3)home A.家 B. 家务()(4)school A.图书馆 B.学校2.看图选单词。
(1)()(2)()(3)()(4)()3.把A栏的英文短语,与B栏对应的汉语意思连起来。
A Bdo homework 下午六点go to bed 做家庭作业at 6:00 pm 在早上have lunch 吃午饭in the morning 上床睡觉get up 看电视have dinner 去上学go to school 吃晚餐watch TV 起床4.写出下列单词的正确形式。
(1)read (现在分词)__________(2)write (现在分词)__________(3)speak(现在分词)__________(4)listen(现在分词)___________(5)teach (单三形式)___________(6)begin(反义词)___________(7)like (单三形式)__________(8)do (否定形式)___________5.()(1)We have dinner ___ 6:00 pm.A. inB. onC.at6.()(2)She ____watching TV.A.likeB.likesC.liking7.()(3)I have ____at 7:00 in the morning.A. breakfastB.lunchC. dinner8.()(4)School ____ over.A.is B .are C.does9.()(5)Lily likes red , ___ Lucy doesn’t like red.A. andB.butC.\10.()(6)Li Yan __ up at 7:00 in the morning.A. getsB. getC.getting11.()(7)I ___Chinese.A. teachB. teachesC.teaching12.()(8)I do ____homework in the evening.A.sheB.myC.me13.在下面的场景下,我们应该说什么。
Lesson 2 What Are You Doing?一、读一读,选出不同类的单词。
( ) 1. A. book B. seeC. boy ( ) 2. A. draw B. nowC. stand ( ) 3. A. dance B. bookC. picture ( ) 4. A. windowB. tall C . school ( ) 5. A. sing B. eatC. train二、先从下列字母中圈出单词,再用其适当形式填空。
1. ________!I see a banana.2. What are you doing ________?3. Lucy is drawing a ________.4. I like to ________ with my crayons.5. I ________ a cow outside the window.三、单项选择。
( ) 1. I am looking out ________ the window ________ the train.A. of ;onB. for ;atC. in ;on( ) 2. Li Ming is ________ reading a book.A. noB. notC. don't( ) 3. There are many tall ________ on the farm.A. treeB. treesC. a tree()4. Some ________ and ________ are playing at school.A. boy;girlB. boys;girlsC. a boy;a girl()5. My father is ________ the picture.A. look atB. looking outC. looking at()6. What do they ________?A. seeB. seesC. to see()7. What ________ Jenny and Lingling doing?A. amB. isC. are()8. Danny is singing a song ________ your mother.A. inB. toC. at()9. —What ________ your cousin like? —Donuts.A. doB. doesC. are()10. Danny,please don't ________.A. pointingB. pointsC. point四、根据句意、图片和首字母提示,补全单词。
Unit 1 SportsLesson 2 At the Sports Shop同步练习一、选词填空。
(有一项多余)this that these those1. people are walking.2. elephant is big.3. trees are far.二、翻译句子。
1. 我们需要一些乒乓球。
2. 你们有T恤衫吗?3. 你想要这些还是那些?4. 那些花是红色的。
三、连词组句。
1. are, these, talking, people.2. football, like, do, this, you, or, football ,that?3. dollars ,these, are, balls, five.4. this, want, one, I.四、按要求完成句子。
1. Do you want these or those?(用these回答)2. I need a T-shirt.(对画线部分提问)3. We have some T-shirts.(改为一般疑问句)五、完成对话。
A: 1. me. Do you have any T-shirts?B: Yes. I'll 2. you!A: Here they are.B: Thanks.A: Do you like this T-shirt 3. that T-shirt, Li Ming?B: I want this one!A: Now we 4. some ping-pong balls. 5. you want these or those?B: I want those!1.__________2.3.4.5.__________参考答案一、1. These 2. This 3. Those二、1. We need some ping-pong balls.2. Do you have any T-shirts?3. Do you want these or those?4. Those flowers are red.三、1. These people are talking.2. Do you like this football or that football?3. These balls are five dollars.4. I want this one.四、1. I want these.2. What do you need?3. Do you have any T-shirts?五、1. Excuse 2. show 3. or 4. need 5. Do第二套一、汉译英。
EXERCISES 2Ⅰ. Write short notes on: Marrakech and Morocco.Suggested Reference Books [SRB]1. any standard gazetteer2. Encyclopaedia BritannicaⅡ.Questions on content:1. Instead of telling the reader that the natives are poor, Orwell shows poverty in at least five ways. Identify them.2. How are people buried in Marrakech?3. Explain the sentence, "All colonial empires are in reality founded upon that fact."(para 3)4. What do you think medieval ghettoes were like?5. Why does the writer say, "A good job Hitler wasn't here"?6. What kind of people, according to Orwell, are partly invisible? Why does he stress this point?7. How was land cultivated in Morocco?8. Why was the old woman surprised when the writer gave her a five-sou piece?9. What did every white man think when he saw a black army marching past?Ⅲ. Questions on appreciation:1. The things of value, Orwell says in "Why I Write, " are always political. Is this essay political? Has the writer said anything of value?2. Orwell describes human suffering and misery rather objectively. How then can you tell that he is outraged at the spectacle of misery?3. Why does the writer reveal his feelings about the donkeys but conceal his feelings about the people? ,What effect does this contrast have on the reader?4. Could paras 4-7 just as well come after 8-15 as before? Could other groups of paragraphs be rearranged? What does this indicate about the organization? What gives the essay coherence?5. Does this essay give readers a new insight into imperialism? Has the writer succeeded in showing that imperialism is an "evil thing" ?6. Comment on Orwell's lucid style and fine attention to significant descriptive details.Ⅳ. Paraphrase:1. The burying-ground is merely a huge waste of hummocky earth, like a derelict building-lot. (para 2)2. All colonial empires are in reality founded upon that fact. (para3)3. They rise out Of the earth, they sweat and starve for a few years, and then they sink back into the nameless mounds of the graveyard (para3)4. A carpenter sits crosslegged at a prehistoric lathe, turning chair-legs at lightning speed. (para 9)5. Instantly, from the dark holes all round, there was a frenzied rush of Jews (para 10)6. every one of them looks on a cigarette as a more or less impossible luxury (para 10)7. Still, a white skin is always fairly conspicuous. (para 16)8. In a tropical landscape one's eye takes in everything except the human beings. (para 16)9. No one would think of running cheap trips to the Distressed Areas. (para 17)10. for nine-tenths of the people the reality of life is an endless, backbreaking struggle to wring a little food out of an eroded soil (para 17)11. She accepted her status as an old woman, that is to say as a beast of burden. (para 19)12. People with brown skins are next door to invisible. (para 21)13. Their splendid bodies were hidden in reach-me-down khaki uniforms (para 23)14. How long before they turn their guns in the other direction? (para 25)15. Every white man there had this thought stowed somewhere or other in his mind. (para 26)Ⅴ. Translate paras 20 and 21 into Chinese.Ⅵ. Look up the dictionary and explain the meaning of the itali-cized words:1. wailing a short chant over and over again (para 2)2. an Arab navvy working on the path nearby (para 6)3. he stowed it gratefully (para 7)4. his left leg is warped out of shape (para 9)5. as the Jews live in a self-contained community (para 11)6. the plough is a wretched wooden thing (para 18)7. all of them are mummified with age and the sun (para 19)8. their splendid bodies were hidden in reach-me-down khaki uniforms (para 23)9. so had the officers on their sweating chargers (para 26) Ⅶ. Discriminate the followi ng groups of synonyms:1. wail, cry, weep, sob, whimper, moan2. frenzy, mania, delirium, hysteria3. glisten, glitter, flash, shimmer, sparkleSuggested Reference Books [ SRB ]1. Webster's New World Dictionary of the American Language2. Webs ter’s New Dictionary of Synonyms3. Reader's Digest, Use the Right WordⅧ. Study the formation of the following compound nouns and list 5-10 examples of each:1. burying-ground2. gravestone3. mid-air4. overcrowding5. nine-tenthsSuggested Reference Books [ SRB ]1. any standard dictionary2. any book on lexicology or word buildingIX. In this essay, the writer makes effective use of specific verbs. List 10 specific verbs you consider used most effectively and give your reasons.Ⅹ.Each of the following sentences may be made more compact by proper subordination. Rewrite them, using subordinate clauses, appositives, prepositional or verbal phrases:1. The British army had lost all its equipment at Dunkirk, and there was only a single armored division left to protect the home island.2.The dry prairie land will drift away in dust storms, but it is still being plowed for profitless wheat farming.3.The educational program may succeed, but it has to have more than mere financial support from the government.4.They have wasted their natural resources, but they should have protected and conserved them.5.The Caldwell family opened the first rough trail and soon other settlers were coming.6. The Smithsonian Institution is constantly working for a better understanding of nature for man's benefit, and it gets little or no publicity.7. Queen Mary was easily shaken by passions. They were both passions of love and passion of hatred and revenge.8. I dreaded opening the door of his office, but it was only fora few days.9. It was early morning and there was a fog and so I crawled out and made my way to the beach.10. I left the door of the safe unlocked and took the leather bag of coins and walked down the street toward the bank.Ⅺ .Read the following paragraphs and then answer the questions: 1) What is the topic sentence? 2) Has the writer succeeded in achievingunity? Give your reasons.1. Life on the farm is an eternal battle against nature. There is always the rush to harvest the crops and to get next year' s grain planted before the fall rains start. To get this accomplished the farmer must be out at work by daybreak. Fruits and vegetables have to be gathered before the early frost; hence everyone is bustling around from morning till night. Fall is beautiful when the leaves on the trees change color and then fall off. Winter sends its warming cover over the froze ground. This causes the animals to hunt for something to eat. There is nothing, so the farmer has to feed them. After his day's work is done, the farmer puts on his slippers, reclines on the davenport in front of the fireplace, and spends a peaceful evening reading. Within a few months spring begins with its beautiful flowers and green grass. The cows give more milk so the farmer has more work to do. After the first spring rain, the corn must be cultivated. As summer ap-proaches the farmer begins to worry for fear that the sun will come up and cook the grain before it is fully developed, or maybe a thunderstorm will come up thus causing his hay crop to rot.2. There are three reasons why I like Japanese food. When I was growing up I never ate Japanese food, since we lived in a part of Texas where there were no Orentals, but now I really like it. One of the best things about Japanese food is that it consists primarily of meat and vegetables, so that it's not at all fattening. However, most Japanese love rice. One of my Japanese friends has at least two bowls of rice at every meal. Another reason for liking Japanese food is that it's always beautifully served, even at lower-priced restaurants. Every dish is a work of art: the chicken yakitori is presented on a gleaming platter crisscrossed with skewers of meat and vegetables, and the shrimp tempura comes on a lovely little bamboo tray. For the American who wants to serve Japanese food like this, these platters and trays may be purchased at a local import store. My final reason for liking Japanese food is its exotic flavor. There is nothing in American or European cuisine quite like the flavor of sashimi (raw fish dipped in soy sauce and horseradish) or shabu-shabu, a meat and vegetable dish that you cook right at your own table by swishing the bite-sized pieces in a pan of seasoned boiling water. Also, from the male point of view, Japanese restaurants are attractive for another reason-- the beautiful little doll-like waitresses, who bow and smile shyly as they serve your food. With all this, is there any wonder Japanese food appeals to me?Ⅻ. Choose the right word from the list below for each blank:fell come did firedpulled feel sagged collapsegoes altered slobbered climbedwent paralysed settled droopingjolt seemed imagined knockfalling tower reaching trumpetedshake cameWhen I ________the trigger I did not hear the bang or____________the kick -- one never does when a shot ___________ home -- but I heard the devilish roar of glee that _________ up from the crowd. In that instant, in too short a time, one would have thought, even for the bullet to get there, a mysterious, terrible change had ________over the elephant. He neither stirred nor_______, but every line of his body had________ He looked suddenly stricken, shrunken, immensely old, as though the frightful impact of the bullet had_________ him without knocking him down. At last, after what _________ a long time -- it might have been five seconds, I dare say – he _______flabbily to his knees. His mouth _______An enormous senility seemed to have ______ upon him. One could have ______him thousands of years old. I _______again into the same spot. At the second shot he did not_______ but ______with desperate slowness to his feet and stood weakly upright, with legs sagging and head _______ . I fired a third time. That was the shot that _______for him. You could see the agony of it _____his whole body and ________ the last remnant of strength from his legs. But in ______ he seemed for a moment to rise, for as his hind legs collapsed beneath him he seemed to_______ upward like a huge rock toppling, his trunk _______skywards like a tree. He________, for the first and only time. And then down he ________, his belly towards me, with a crash that seemed to _________ the ground even where I lay.XIII. Topics for oral work:1. What can you infer about the author's political attitude from this essay?2. Do you like Orwell' s style? Give examples to support your XIV. Write a short composition describing objectively the suffering and poverty of pre-liberation China or of any city. Try to maintain an objective tone, but your real feelings should be ev- ident to the reader.习题全解Ⅰ . Marrakech: in west central Morocco, at the Northern foot of the high Atlas, 130 miles south of Casablanca, the chief seaport. The city renowned for leather goods, is one of the principal commercial centersof Morocco. It was founded in 1062 and was the capital of Morocco from then until 1147 and again from 1550 to 1660. It was captured by the French in 1912, when its modern growth began. It has extremely hot summers but mild winters. Yearly rainfall is 9 inches and limited to winter months. The city was formerly also called Morocco.Morocco: Located in North Africa, on the Mediterranean Sea and the Atlantic Ocean. Morocco is the farthest west of all the Arab countries. Rabat is the capital. The estimated population in 1973 was 15,600,000. About 2000 B. C. it was settled by Berber tribes, who have formed the basis of the population ever since. The Arabs invaded Morocco in the 7thcentury, bringing with them Islam. From the end of the 17thcentury until the early 19th century Morocco was almost entirely free from foreign influence. But in 1912, a Franco- Spanish agreement divided Morocco into 4 administrative zones. It gained independence in 1956 and became a constitutional monarchy in 1957. Morocco is a member of the United Nations, the League of Arab States, and the Organization of African Unity. Moroccans are mainly farmers (70%)who try to grow their own food. They often use camels, donkeys and mules to pull their plows. In the south a few tribesmen still, wander from place to place in the desert.Ⅱ. 1. Here are five things he describes to show poverty- (a) the burial of the poor inhabitants (b)an Arab Navvy, an employee of the municipality, begging for a piece of bread (c)the miserable lives of the Jews in the ghettoes~ (d)cultivation of the poor soil; (e) the old women carrying fire wood.2. See paragraphs 1 and 2.3. All the imperialists build up their empires by treating the people in the colonies as animals instead of as human be rags.4. Medieval ghettoes were probably like the Jewish quarters in Marrakech--overcrowded, thousands of people living in a narrow street, houses completely windowless, and the whole area dirty and unhygienic.5. If Hitler were here, all the Jews would have been massacred.6. Those who work with their hands are partly invisible. It’s only because of this that the starved countries of Asia and Africa are accepted as tourist resorts. The people are not treated as human beings, and it is on this fact that all colonial empires are in reality founded.7. See paragraph 18.8. The old woman was surprised because someone was taking notice of her and treating her as a human being. She accepted her status as an old woman, that is to say, as a beast of burden.9, Every white man thought. "How much longer can we go on kidding these people? How long before they turn their guns in the otherdirection?" They knew they could not go on fooling these black people any longer. Some day they would rise up in revolt and free themselves. Ⅲ. 1. Yes, it is. In this essay Orwell denounces the evils of colonialism or imperialism by mercilessly exposing the poverty, misery and degradation of the native people in the colonies.2. He manages to show that he is outraged at the spectacle of misery, first, through the appropriate use of words second, through the clever choice of the scenes he describes; third, through the tone in which he describes these scenes and finally, by contrasting the indignation at the cruel handling of the donkey with the unconcern towards the fate of the human beings.3. Because that shows the cruel treatment the donkeys receive evokes a greater feeling of sympathy in the breasts of the white masters than the miserable fate of the people. This contrast have on the reader an effect that the people are not considered nor treated as human beings.4. Paragraphs 4-7 could as well come after 8-15 as before. Other groups of paragraphs could be rearranged. This indicates that the whole passage is made up of various independent examples or illustrations of the people's poverty and suffering. The central theme--all colonial empires are in reality founded upon thisfact--gives unity and cohesion to the whole essay.5. This essay gives a new insight into imperialism. Yes, he has succeeded in showing that imperialism is an "evil thing".6. Orwell is good at the appropriate use of simple but forceful words and the clever choice of the scenes he describes. His lucid style and fine attention to significant descriptive details efficiently conveyed to the readers the central idea "all colonial empires are in reality founded upon this fact", the fact that the people are not considered or treated as human beings.IV. 1. The buring-ground is nothing more than a huge piece of wasteland full of mounds of earth looking like a deserted and abandoned piece of land on which a building was going to be put up.2. All the imperialists build up their empires by treating the people in the colonies like animals (by not treating the people in the colonies as human beings).3. They are born. Then for a few years they work, toil and starve. Finally they die and are buried in graves without a name.4. Sitting with his legs crossed and using a very old-fashioned lathe, a carpenter quickly gives a round shape to the chair-legs he is making.5. Immediately from their dark hole-like cells everywhere a great number of Jews rushed out wildly excited.6. Every one of these poor Jews looked on the cigarette as a pieceof luxury which they could not possibly afford.7. However, a white-skinned European is always quite noticeable.8. If you take a look at the natural scenery in a tropical region, you see everything but the human beings.9. No one would think of organizing cheap trips for the tourists to visit the poor slum areas (for these trips 42V.Ⅵ.Ⅶ. would not be interesting).10.life is very hard for ninety percent of the people.With hard backbreaking toil they can produce a little food on the poor soil. 11.She took it for granted that as an old woman she was the lowest in the community,that。
EXERCISES 2Ⅰ. Write short notes on: Marrakech and Morocco.Suggested Reference Books [SRB]1. any standard gazetteer2. Encyclopaedia BritannicaⅡ.Questions on content:1. Instead of telling the reader that the natives are poor, Orwell shows poverty in at least five ways. Identify them.2. How are people buried in Marrakech?3. Explain the sentence, "All colonial empires are in reality founded upon that fact."(para 3)4. What do you think medieval ghettoes were like?5. Why does the writer say, "A good job Hitler wasn't here"?6. What kind of people, according to Orwell, are partly invisible? Why does he stress this point?7. How was land cultivated in Morocco?8. Why was the old woman surprised when the writer gave her a five-sou piece?9. What did every white man think when he saw a black army marching past?Ⅲ. Questions on appreciation:1. The things of value, Orwell says in "Why I Write, " are always political. Is this essay political? Has the writer said anything of value?2. Orwell describes human suffering and misery rather objectively. How then can you tell that he is outraged at the spectacle of misery?3. Why does the writer reveal his feelings about the donkeys but conceal his feelings about the people? ,What effect does this contrast have on the reader?4. Could paras 4-7 just as well come after 8-15 as before? Could other groups of paragraphs be rearranged? What does this indicate about the organization? What gives the essay coherence?5. Does this essay give readers a new insight into imperialism? Has the writer succeeded in showing that imperialism is an "evil thing" ?6. Comment on Orwell's lucid style and fine attention to significant descriptive details.Ⅳ. Paraphrase:1. The burying-ground is merely a huge waste of hummocky earth, like a derelict building-lot. (para 2)2. All colonial empires are in reality founded upon that fact. (para3)3. They rise out Of the earth, they sweat and starve for a few years, and then they sink back into the nameless mounds of the graveyard (para3)4. A carpenter sits crosslegged at a prehistoric lathe, turning chair-legs at lightning speed. (para 9)5. Instantly, from the dark holes all round, there was a frenzied rush of Jews (para 10)6. every one of them looks on a cigarette as a more or less impossible luxury (para 10)7. Still, a white skin is always fairly conspicuous. (para 16)8. In a tropical landscape one's eye takes in everything except the human beings. (para 16)9. No one would think of running cheap trips to the Distressed Areas. (para 17)10. for nine-tenths of the people the reality of life is an endless, backbreaking struggle to wring a little food out of an eroded soil (para 17)11. She accepted her status as an old woman, that is to say as a beast of burden. (para 19)12. People with brown skins are next door to invisible. (para 21)13. Their splendid bodies were hidden in reach-me-down khaki uniforms (para 23)14. How long before they turn their guns in the other direction? (para 25)15. Every white man there had this thought stowed somewhere or other in his mind. (para 26)Ⅴ. Translate paras 20 and 21 into Chinese.Ⅵ. Look up the dictionary and explain the meaning of the itali-cized words:1. wailing a short chant over and over again (para 2)2. an Arab navvy working on the path nearby (para 6)3. he stowed it gratefully (para 7)4. his left leg is warped out of shape (para 9)5. as the Jews live in a self-contained community (para 11)6. the plough is a wretched wooden thing (para 18)7. all of them are mummified with age and the sun (para 19)8. their splendid bodies were hidden in reach-me-down khaki uniforms (para 23)9. so had the officers on their sweating chargers (para 26) Ⅶ. Discriminate the followi ng groups of synonyms:1. wail, cry, weep, sob, whimper, moan2. frenzy, mania, delirium, hysteria3. glisten, glitter, flash, shimmer, sparkleSuggested Reference Books [ SRB ]1. Webster's New World Dictionary of the American Language2. Webs ter’s New Dictionary of Synonyms3. Reader's Digest, Use the Right WordⅧ. Study the formation of the following compound nouns and list 5-10 examples of each:1. burying-ground2. gravestone3. mid-air4. overcrowding5. nine-tenthsSuggested Reference Books [ SRB ]1. any standard dictionary2. any book on lexicology or word buildingIX. In this essay, the writer makes effective use of specific verbs. List 10 specific verbs you consider used most effectively and give your reasons.Ⅹ.Each of the following sentences may be made more compact by proper subordination. Rewrite them, using subordinate clauses, appositives, prepositional or verbal phrases:1. The British army had lost all its equipment at Dunkirk, and there was only a single armored division left to protect the home island. dry prairie land will drift away in dust storms, but it is still being plowed for profitless wheat farming.educational program may succeed, but it has to have more than mere financial support from the government.have wasted their natural resources, but they should have protected and conserved them.Caldwell family opened the first rough trail and soon other settlers were coming.6. The Smithsonian Institution is constantly working for a better understanding of nature for man's benefit, and it gets little or no publicity.7. Queen Mary was easily shaken by passions. They were both passions of love and passion of hatred and revenge.8. I dreaded opening the door of his office, but it was only fora few days.9. It was early morning and there was a fog and so I crawled out and made my way to the beach.10. I left the door of the safe unlocked and took the leather bag of coins and walked down the street toward the bank.Ⅺ .Read the following p aragraphs and then answer the questions: 1) What is the topic sentence? 2) Has the writer succeeded in achievingunity? Give your reasons.1. Life on the farm is an eternal battle against nature. There is always the rush to harvest the crops and to get next year' s grain planted before the fall rains start. To get this accomplished the farmer must be out at work by daybreak. Fruits and vegetables have to be gathered before the early frost; hence everyone is bustling around from morning till night. Fall is beautiful when the leaves on the trees change color and then fall off. Winter sends its warming cover over the froze ground. This causes the animals to hunt for something to eat. There is nothing, so the farmer has to feed them. After his day's work is done, the farmer puts on his slippers, reclines on the davenport in front of the fireplace, and spends a peaceful evening reading. Within a few months spring begins with its beautiful flowers and green grass. The cows give more milk so the farmer has more work to do. After the first spring rain, the corn must be cultivated. As summer ap-proaches the farmer begins to worry for fear that the sun will come up and cook the grain before it is fully developed, or maybe a thunderstorm will come up thus causing his hay crop to rot.2. There are three reasons why I like Japanese food. When I was growing up I never ate Japanese food, since we lived in a part of Texas where there were no Orentals, but now I really like it. One of the best things about Japanese food is that it consists primarily of meat and vegetables, so that it's not at all fattening. However, most Japanese love rice. One of my Japanese friends has at least two bowls of rice at every meal. Another reason for liking Japanese food is that it's always beautifully served, even at lower-priced restaurants. Every dish is a work of art: the chicken yakitori is presented on a gleaming platter crisscrossed with skewers of meat and vegetables, and the shrimp tempura comes on a lovely little bamboo tray. For the American who wants to serve Japanese food like this, these platters and trays may be purchased at a local import store. My final reason for liking Japanese food is its exotic flavor. There is nothing in American or European cuisine quite like the flavor of sashimi (raw fish dipped in soy sauce and horseradish) or shabu-shabu, a meat and vegetable dish that you cook right at your own table by swishing the bite-sized pieces in a pan of seasoned boiling water. Also, from the male point of view, Japanese restaurants are attractive for another reason-- the beautiful little doll-like waitresses, who bow and smile shyly as they serve your food. With all this, is there any wonder Japanese food appeals to me?Ⅻ. Choose the right word from the list below for each blank:fell come did firedpulled feel sagged collapsegoes altered slobbered climbedwent paralysed settled droopingjolt seemed imagined knockfalling tower reaching trumpetedshake cameWhen I ________the trigger I did not hear the bang or____________the kick -- one never does when a shot ___________ home -- but I heard the devilish roar of glee that _________ up from the crowd. In that instant, in too short a time, one would have thought, even for the bullet to get there, a mysterious, terrible change had ________over the elephant. He neither stirred nor_______, but every line of his body had________ He looked suddenly stricken, shrunken, immensely old, as though the frightful impact of the bullet had_________ him without knocking him down. At last, after what _________ a long time -- it might have been five seconds, I dare say – he _______flabbily to his knees. His mouth _______An enormous senility seemed to have ______ upon him. One could have ______him thousands of years old. I _______again into the same spot. At the second shot he did not_______ but ______with desperate slowness to his feet and stood weakly upright, with legs sagging and head _______ . I fired a third time. That was the shot that _______for him. You could see the agony of it _____his whole body and ________ the last remnant of strength from his legs. But in ______ he seemed for a moment to rise, for as his hind legs collapsed beneath him he seemed to_______ upward like a huge rock toppling, his trunk _______skywards like a tree. He________, for the first and only time. And then down he ________, his belly towards me, with a crash that seemed to _________ the ground even where I lay.XIII. Topics for oral work:1. What can you infer about the author's political attitude from this essay?2. Do you like Orwell' s style? Give examples to support your XIV. Write a short composition describing objectively the suffering and poverty of pre-liberation China or of any city. Try to maintain an objective tone, but your real feelings should be ev- ident to the reader.习题全解Ⅰ . Marrakech: in west central Morocco, at the Northern foot of the high Atlas, 130 miles south of Casablanca, the chief seaport. The city renowned for leather goods, is one of the principal commercial centersof Morocco. It was founded in 1062 and was the capital of Morocco from then until 1147 and again from 1550 to 1660. It was captured by the French in 1912, when its modern growth began. It has extremely hot summers but mild winters. Yearly rainfall is 9 inches and limited to winter months. The city was formerly also called Morocco.Morocco: Located in North Africa, on the Mediterranean Sea and the Atlantic Ocean. Morocco is the farthest west of all the Arab countries. Rabat is the capital. The estimated population in 1973 was 15,600,000. About 2000 B. C. it was settled by Berber tribes, who have formed the basis of the population ever since. The Arabs invaded Morocco in the 7thcentury, bringing with them Islam. From the end of the 17thcentury until the early 19th century Morocco was almost entirely free from foreign influence. But in 1912, a Franco- Spanish agreement divided Morocco into 4 administrative zones. It gained independence in 1956 and became a constitutional monarchy in 1957. Morocco is a member of the United Nations, the League of Arab States, and the Organization of African Unity. Moroccans are mainly farmers (70%)who try to grow their own food. They often use camels, donkeys and mules to pull their plows. In the south a few tribesmen still, wander from place to place in the desert.Ⅱ. 1. Here are five things he describes to show poverty- (a) the burial of the poor inhabitants (b)an Arab Navvy, an employee of the municipality, begging for a piece of bread (c)the miserable lives of the Jews in the ghettoes~ (d)cultivation of the poor soil; (e) the old women carrying fire wood.2. See paragraphs 1 and 2.3. All the imperialists build up their empires by treating the people in the colonies as animals instead of as human be rags.4. Medieval ghettoes were probably like the Jewish quarters in Marrakech--overcrowded, thousands of people living in a narrow street, houses completely windowless, and the whole area dirty and unhygienic.5. If Hitler were here, all the Jews would have been massacred.6. Those who work with their hands are partly invisible. It’s only because of this that the starved countries of Asia and Africa are accepted as tourist resorts. The people are not treated as human beings, and it is on this fact that all colonial empires are in reality founded.7. See paragraph 18.8. The old woman was surprised because someone was taking notice of her and treating her as a human being. She accepted her status as an old woman, that is to say, as a beast of burden.9, Every white man thought. "How much longer can we go on kidding these people? How long before they turn their guns in the otherdirection?" They knew they could not go on fooling these black people any longer. Some day they would rise up in revolt and free themselves. Ⅲ. 1. Yes, it is. In this essay Orwell denounces the evils of colonialism or imperialism by mercilessly exposing the poverty, misery and degradation of the native people in the colonies.2. He manages to show that he is outraged at the spectacle of misery, first, through the appropriate use of words second, through the clever choice of the scenes he describes; third, through the tone in which he describes these scenes and finally, by contrasting the indignation at the cruel handling of the donkey with the unconcern towards the fate of the human beings.3. Because that shows the cruel treatment the donkeys receive evokes a greater feeling of sympathy in the breasts of the white masters than the miserable fate of the people. This contrast have on the reader an effect that the people are not considered nor treated as human beings.4. Paragraphs 4-7 could as well come after 8-15 as before. Other groups of paragraphs could be rearranged. This indicates that the whole passage is made up of various independent examples or illustrations of the people's poverty and suffering. The central theme--all colonial empires are in reality founded upon thisfact--gives unity and cohesion to the whole essay.5. This essay gives a new insight into imperialism. Yes, he has succeeded in showing that imperialism is an "evil thing".6. Orwell is good at the appropriate use of simple but forceful words and the clever choice of the scenes he describes. His lucid style and fine attention to significant descriptive details efficiently conveyed to the readers the central idea "all colonial empires are in reality founded upon this fact", the fact that the people are not considered or treated as human beings.IV. 1. The buring-ground is nothing more than a huge piece of wasteland full of mounds of earth looking like a deserted and abandoned piece of land on which a building was going to be put up.2. All the imperialists build up their empires by treating the people in the colonies like animals (by not treating the people in the colonies as human beings).3. They are born. Then for a few years they work, toil and starve. Finally they die and are buried in graves without a name.4. Sitting with his legs crossed and using a very old-fashioned lathe, a carpenter quickly gives a round shape to the chair-legs he is making.5. Immediately from their dark hole-like cells everywhere a great number of Jews rushed out wildly excited.6. Every one of these poor Jews looked on the cigarette as a pieceof luxury which they could not possibly afford.7. However, a white-skinned European is always quite noticeable.8. If you take a look at the natural scenery in a tropical region, you see everything but the human beings.9. No one would think of organizing cheap trips for the tourists to visit the poor slum areas (for these trips 42V.Ⅵ.Ⅶ. would not be interesting).10.life is very hard for ninety percent of the people.With hard backbreaking toil they can produce a little food on the poor soil. 11.She took it for granted that as an old woman she was the lowest in the 。
练习2
1. 创建一个查询,显示收入超过$12,000 的雇员的名字和薪水。
将SQL 语句存到文件
lab2_1.sql 中,运行该查询。
SELECT last_name, salary
FROM employees
WHERE salary > 12000;
2. 创建一个查询,显示雇员号为176 的雇员的名字和部门号。
SELECT last_name, department_id
FROM employees
WHERE employee_id = 176;
3. 修改lab2_1.sql 文件,显示所有薪水不在5000 和12000 之间的雇员的名字和薪水。
将SQL 语句存到文件lab2_3.sql 中。
SELECT last_name, salary
FROM employees
WHERE salary NOT BETWEEN 5000 AND 12000;
4. 显示受雇日期在2002年2月20日和2003年5月1日之间的雇员的名字、岗位和
受雇日期。
按受雇日期顺序排序查询结果。
SELECT last_name, job_id, hire_date
FROM employees
WHERE hire_date BETWEEN '2002-02-20' AND '2003-5-01'
ORDER BY hire_date;
5. 显示所有在部门20 和50 中的雇员的名字和部门号,并以名字按字母顺序排序。
SELECT last_name, department_id
FROM employees
WHERE department_id IN (20, 50)
ORDER BY last_name;
6. 修改lab2_3.sql 列出收入在$5,000 和$12,000 之间,并且在部门20 或50 工作的
雇员的名字和薪水。
将列标题分别显示为Employee 和Monthly Salary,将
lab2_3.sql 保存为lab2_6.sql。
运行lab2_6.sql 中的语句。
SELECT last_name "Employee", salary "Monthly Salary"
FROM employees
WHERE salary BETWEEN 5000 AND 12000
AND department_id IN (20, 50);
7. 显示每一个在1994 年受雇的雇员的名字和受雇日期。
SELECT last_name, hire_date
FROM employees
WHERE hire_date LIKE '2004%';
8. 显示所有没有主管经理的雇员的名字和工作岗位。
SELECT last_name, job_id
FROM employees
WHERE manager_id IS NULL;
9. 显示所有有佣金的雇员的名字、薪水和佣金。
以薪水和佣金的降序排序数据。
SELECT last_name, salary, commission_pct
FROM employees
WHERE commission_pct IS NOT NULL
ORDER BY salary DESC, commission_pct DESC;
如果你有时间,完成下面的练习:
10. 显示所有名字中第三个字母是a 的雇员的名字。
SELECT last_name
FROM employees
WHERE last_name LIKE '__a%';
11. 显示所有名字中有一个a 和一个e 的雇员的名字。
SELECT last_name
FROM employees
WHERE last_name LIKE '%a%'
AND last_name LIKE '%e%';
如果你想要额外的挑战,完成下面的练习:
12. 显示所有工作是销售代表或者普通职员,并且薪水不等于$2,500、$3,500 或$7,000
的雇员的名字、工作和薪水。
SELECT last_name, job_id, salary
FROM employees
WHERE job_id IN ('SA_REP', 'ST_CLERK')
AND salary NOT IN (2500, 3500, 7000);
13. 修改lab2_6.sql 显示所有佣金总计为20% 的雇员的名字、薪水和佣金。
保存
lab2_6.sql 为lab2_13.sql。
再运行lab2_13.sql 中的语句。
SELECT last_name "Employee", salary "Monthly Salary",
commission_pct
FROM employees
WHERE commission_pct = 0.20;。