1、
CREATE TABLE `科室` (
`科室号` VARCHAR(32) NOT NULL,
`科室名` VARCHAR(100) NULL DEFAULT NULL,
`值班电话` VARCHAR(20) NULL DEFAULT NULL,
PRIMARY KEY (`科室号`)
)
2、
select * from '医生' where 职称='主任医师'
3、
select '病人'.姓名,'病人'.'出生日期' from '病人','门诊记录' where '病人'.'病人编号'='门诊记录'.'病人编号' and '门诊记录'.'日期'='2017年11月11日'
4、
select '科室'.'科室号',count('门诊记录'.'门诊号') as cc, from '科室','医生','门诊记录' where '科室'.'科室号'='医生'.'所属科室号' and '医生'.'工号'='门诊记录'.'工号'
group by '科室'.'科室号'
order by cc desc limit 1
5、
select * from '病人','门诊记录' where '病人'.'病人编号'='门诊记录'.'病人编号' and '门诊记录'.'诊断' like '%高血压%'
6、
update '医生' set '状态'='退休' where '姓名'='贾宁'
追问谢谢,可以再帮忙看一下另外类似的一题的四、五两问怎么写吗
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3812b31bb051f8194eb40229d5b44aed2f73e7c4?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)