一
create database factory on
primary
(
name=factory_data,
filename='d:\dbf\factory_data.mdf',
size=3mb,
filegrowth=5mb
)
log on
(
name=factory_log,
filename='d:\dbf\factory_log.ldf',
size=3mb,
filegrowth=1mb
)
二
create table depart
(
deptid char(4) not null primary key,
deptname varchar(10) not null
)
create table worker
(
workerid char(6) not null primary key,
workername varchar(20) not null,
workersex char(1) not null,
birthdate smalldatetime not null,
party char(1),
work varchar(10),
deptid char(4) constraint fk_deptid FOREIGN KEY REFERENCES depart(deptid)
)
go
create table salary
(
workerid char(6) not null constraint fk_workerid FOREIGN KEY REFERENCES worker(workerid),
datet datetime not null,
salary money
)
数据自己使用insert语句插入吧
三、
select datediff(year,birthdate,getdate()) as age from worker
select deptid,count(*) from worker where party='1' group by deptid
select worker.workerid,workername,avg(salary)
from worker,salary where worker.workerid=salary.workerid group by worker.workerid,workername
select deptname,avg(salary) as 部门平均工资 from salary,worker,depart
where salary.workerid=worker.workerid and worker.deptid=depart.deptid group by deptname having avg(salary) > 1200
select worker.*,deptname from worker join depart on worker.deptid=depart.deptid
温馨提示:答案为网友推荐,仅供参考