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