单选题

某打车公司将驾驶里程（drivedistanced）超过5000里的司机信...

Question

某打车公司要将驾驶里程（drivedistanced）超过5000里的司机信息转存到一张称为seniordrivers 的表中，他们的详细情况被记录在表drivers 中，正确的sql语句为（）

A. insert into seniordrivers where drivedistanced>=5000 from drivers

B. insert into seniordrivers(drivedistanced) values from drivers where drivedistanced>=5000

C. insert into seniordrivers(drivedistanced) where values>=5000 from drivers

D. select * into seniordrivers from drivers where drivedistanced >=5000