创建雇员表emp（id， name，sex，job，joindate，salary，dept）注：salary为薪水，dept为雇员所在的部门编号，分别给emp表设置主键，为name设置唯一性约束，sex做检查约束令其值只能为男或女
给emp表插入一条数据，并查询工资高于500或是岗位为MANAGER的雇员，同时还要满足他们的姓名首写字母为大写的J；统计各个部门雇员人数
请知道的孩纸 +Q363513100 或者把代码 直接发到我邮箱363513100@qq.com
速度哦！！！
create table emp
(
id number(10) unique not null,
name varchar2(10) unique not null,
sex varchar2(2) not null check (sex in('男','女')),
job varchar2(20),
joindate date,
salary number(20),
dept varchar2(20),
constraint PK_EMP primary key(id,name)
);
insert into emp values
(1,'陈冠希','男','电影','2000-09-09',10000,'英皇');
select id,name
from emp
where name is like 'J%' and (salary>500 or job='MANAGER');
select dept,count(id)
from emp
group by dept;
(
id number(10) unique not null,
name varchar2(10) unique not null,
sex varchar2(2) not null check (sex in('男','女')),
job varchar2(20),
joindate date,
salary number(20),
dept varchar2(20),
constraint PK_EMP primary key(id,name)
);
insert into emp values
(1,'陈冠希','男','电影','2000-09-09',10000,'英皇');
select id,name
from emp
where name is like 'J%' and (salary>500 or job='MANAGER');
select dept,count(id)
from emp
group by dept;
温馨提示：答案为网友推荐，仅供参考
