高等继续教育 / 数据库应用技术
题型描述: 问答题
汽车保险数据库包含如下关系模式:
Clients (Driver-id, Cname, Address)
Cars (Car-no, Model, Year)
Accidents (Report-no, Date, Location)
Owns (Driver-id, Car-no)
Participated (Diver-id, Car-no, Report-no, Damage-amount)
用T-SQL写出2006年其车辆出过事故的总人数。
汽车保险数据库包含如下关系模式:
Clients (Driver-id, Cname, Address)
Cars (Car-no, Model, Year)
Accidents (Report-no, Date, Location)
Owns (Driver-id, Car-no)
Participated (Diver-id, Car-no, Report-no, Damage-amount)
用T-SQL写出2006年其车辆出过事故的总人数。
参考答案:
佳题速递: