第(31)到(35)题使用的“部门”表和“职工:”表的表结构如下:部门(部门号C(2)、部门名称C(10))职工(部门号C(2)、职工号C(4)、姓名C(8)、基本工资N(7,2)) 检索每个部门的职工工资的总和,要求显示“部门名称”和“基本工资”,正确的命令是( )。
A. SELECT 部门名称,SUM (基本工资) FROM 部门,职工;
B. WHERE 职工.部门号=部门.部门号:
C. ORDER BY 部门号
D. SELECT 部门名称,SUM (基本工资) FROM 部门,职工;
E. WHERE 职工.部门号=部门.部门号;
F. GROUP BY 部门号
G. SELECT 部门名称,SUM (基本工资) FROM 部门,职工;
H. WHERE 职工.部门号=部门.部门号;
I. ORDRE BY 职工.部门号
J. SELECT 部门名称,SUM (基本工资) FROM 部门,职工;
K. WHERE 职工.部门号=部门.部门号;
L. GROUP BY 职工.部门号
查看答案
NEW JOBSA new clothing company is hoping to create as (29) as 500 jobs in its factory and nationwide chain of stores. The company, New Trend was set (30) by Peter Dalton, a 36-year-old businessman (31) Liverpool.The company, (32) is due to start production early next year, will provide employment (33) 300 people in its factory on the edge of Liverpool. In 12 months’ time, (34) will be a further 200 jobs, as the company begins opening shops in towns in (35) parts of Britain.Peter Dalton is also (36) to open a shop in New York. He hopes that (37) this shop proves successful, the chain (38) expand across the whole of North America. ’This project has (39) me over four years to finalise,’ says Peter Dalton, ’and (40) that it’s finally getting started, I’m really excited.’ 33()
A. by
B. on
C. for
Northern Software24 Queens Road, ChapeltownTo: Jean Palmer, PurchasingFrom: Tom Milton, AccountsDate: 1 March 2002Subject: EnvelopesWe’ve run out of the envelopes we use for mailing invoices - the white ones with windows. I need some more tomorrow - I don’t want to delay sending the customer bills this month, so please order the envelopes today, and have them delivered as soon as possible. I’ve got about 200 invoices to post.HAYES OFFICE SUPPLIESReductions on some product linesBrown or white envelopes (supplied in quantities of 100, 500 or 1000)-15% off catalogue priceProduct code: EV300 (plain) or EV311 (with window)Three delivery services available:one week (free)four days (minimum charge ~2)next day (minimum charge ~5)101 Leeds Road, ChapeltownTel: 275 9087 Fax: 275 9088ORDER FORMCompany name: (41) ______Delivery address: (42) ______, ChapeltownProduct code: (43) ______Colour: (44) ______Quantity: 500Delivery service required: (45) ______ 45()
The jewellery designerHe was young and completely unknown, but Paul Waterhouse believed in himself. He’d heard that there was going to be a large exhibition for jewellery designers and he asked the organisers whether he could show some of his work. ’I was only 21,’ he says, ’and they agreed, if I could show a complete collection.’ So he went to the bank, borrowed £1,500 for materials, and began to work on new designs. ’The exhibition was fantastic. Although everyone else was much more experienced than I was, my designs were still praised.’He decided to transfer his business to Canada and began to experiment with new materials: all sorts of stones from around the world, some totally new to him. ’As most of them weren’t precious, it changed the way I approached design. It was great! I was able to produce much larger pieces of modern jewellery,’ he says. ’Then I was asked by an advertising agency to design a wedding ring for a TV advert. The agency liked what I’d done, but their client, a car manufacturer, wanted something a little more traditional. I was happy to make changes and that work gave me a lot of free publicity.’ Paul was willing to compromise on the design of the ring.()
A. Right
B. Wrong
C. Doesn’t say
NEW JOBSA new clothing company is hoping to create as (29) as 500 jobs in its factory and nationwide chain of stores. The company, New Trend was set (30) by Peter Dalton, a 36-year-old businessman (31) Liverpool.The company, (32) is due to start production early next year, will provide employment (33) 300 people in its factory on the edge of Liverpool. In 12 months’ time, (34) will be a further 200 jobs, as the company begins opening shops in towns in (35) parts of Britain.Peter Dalton is also (36) to open a shop in New York. He hopes that (37) this shop proves successful, the chain (38) expand across the whole of North America. ’This project has (39) me over four years to finalise,’ says Peter Dalton, ’and (40) that it’s finally getting started, I’m really excited.’ 34()
A. it
B. they
C. there