某打车公司要将驾驶里程(drivedistanced)超过5000里的司机信息转存到一张称为seniordrivers 的表中,他们的详细情况被记录在表drivers 中,正确的sql语句为()
A.
insert into seniordrivers
drivedistanced>=5000 from drivers where
B.
insert seniordrivers (drivedistanced) values from drivers where drivedistanced>=5000
C.
insert into seniordrivers
(drivedistanced)values>=5000 from drivers where
D.
select * into seniordrivers from drivers where drivedistanced >=5000