1、共（6分）

（1）（2分）

CREATE TABLE FleetInfo(

FleetID INT PRIMARY KEY,

FleetName CHAR(20) NOT NULL,

FleetAddress CHAR(40) NULL);

（2）（2分）

CREATE TABLE DriverInfo(

DriverID INT PRIMARY KEY,

FleetID INT NOT NULL,

DriverName CHAR(20) NOT NULL,

DriverAge INT NOT NULL,

DriverSex CHAR(4) CHECK(DriverSex IN('男','女')),

LicenseID CHAR(40) NULL,

Telephone CHAR(11) NULL,

DriverAddress CHAR(40) NULL,

FOREIGN KEY(FleetID) REFERENCES FleetInfo(FleetID)

);

（3）（2分）

CREATE TABLE VehicleInfo(

VehicleID INT PRIMARY KEY,

VehicleType CHAR(4) NOT NULL,

VehicleColour CHAR(8) NOT NULL,

VehicleLoad NUMERIC(3,0) NULL);

2、（2分）

SELECT * FROM FleetInfo WHERE FleetAddress LIKE '%新华区%';

3、（2分）

SELECT VehicleID,VehicleType FROM VehicleInfo WHERE VehicleColour = '蓝色';

4、（3分）

SELECT DriverID,DriverName,DriverAge,DriverSex,Telephone FROM DriverInfo WHERE DriverSex = '女' AND DriverAge>30;

5、（3分）

SELECT FleetName,DriverID,DriverName,DriverAge,DriverAddress FROM FleetInfo,DriverInfo WHERE FleetInfo.FleetID=DriverInfo.FleetID AND FleetInfo.FleetID=2 AND FleetInfo.FleetName LIKE '%石家庄%' AND FleetInfo.FleetAddress LIKE '%桥东区%' AND DriverInfo.DriverAge BETWEEN 20 AND 30;

6、（4分）

CREATE VIEW DriverAverAge AS SELECT DriverID,DriverSex,AVG(DriverAge) FROM DriverInfo GROUP BY DriverSex;