第一题:
update CAR_RECORD set Car_Color = 'yellow' where Car_Num = "浙A12A26";
第二题:
select Rec_type as '违法类型',count(Rec_Type) as '数量' from CAR_DPRECORD group by Rec_type;
第三题:
select avg(Car_Speed) from CAR_RECORD inner join CAR_DPRECORD on CAR_RECORD.Car_Num = CAR_DPRECORD.Car_Num and CAR_RECORD.Car_Type = 2;