针对公交公司数据库,现需要统计每个公交公司的平均里程数,以及线路数量,以下正确的是( )
A.
SELECT company,COUNT(*),AVG(miles) FROM line GROPU BY company
B.
SELECT company,COUNT(*) FROM line GROPU BY company
C.
SELECT * FROM line GROPU BY company
D.
SELECT company,COUNT(*),AVG(miles) FROM line GROPU BY miles