高等继续教育 / 数据库应用技术
题型描述: 计算题
汽车保险数据库包含如下关系模式:
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写出与王明的车有关的事故数量。
汽车保险数据库包含如下关系模式:
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写出与王明的车有关的事故数量。
参考答案:
佳题速递: