第(31)到(35)题使用的“部门”表和“职工:”表的表结构如下:部门(部门号C(2)、部门名称C(10))职工(部门号C(2)、职工号C(4)、姓名C(8)、基本工资N(7,2)) 检索最少有5名职工的每个部门的职工基本工资的总额( )。
A. SELECT 部门号,COUNT(*),SUM (基本工资) FROM 职工;
B. HAVING COUNT(*)>=5
C. SELECT 部门号,COUNT(*),SUM(基本工资) FROM 职工;
D. GROUP BY 基本工资 HAVING COUNT (*)>=5
E. SELECT 部门号,COUNT(*),SUM (基本工资) FROM 职工;
F. GROUP BY 部门号 HAVING COUNT(*)>=5
G. SELECT 部门号,COUNT(*),SUM (基本工资) FROM 职工;
H. GROUP BY 部门号 WHERE COINT (*)>=5
查看答案
NEW RACETRACK IN BRAMFORDNew racetrack will be where the (16) ______ used to be.Work begins: (17) ______PARTNERS: SPC and RunwellsSPC will provide an on-site (18) ______ and a sports caf6.Runwells manufacture (19) ______Runwells will provide everyone with (20) ______TRACK USE:- racing twice a month- Police and ambulance need it for (21) ______ their drivers.FUTURE PLANS:- possibility of building a (22) ______ 22()
Sales trip to Paris - train detailsDeparture time: (9) ______Train number: (10) ______Coach and seat number: (11) ______Price charged: (12) ______Check-in desk: (13) ______Booking reference: (14) ______Contact name: (15) ______ 13()
Sales trip to Paris - train detailsDeparture time: (9) ______Train number: (10) ______Coach and seat number: (11) ______Price charged: (12) ______Check-in desk: (13) ______Booking reference: (14) ______Contact name: (15) ______ 14()
After Geraldine found premises, it was difficult for her to()
A. run both parts of the business.
B. find enough clients to deliver to.
C. afford the rent of the buildin