现有表Employee，字段：id (int)，firstname(varchar), lastname(varchar); 以下sql语句错误的是

A.select firstname '.' lastname as 'name' from employee

B.select firstname '.' lastname='name' from employee

C.select 'name'=firstname '.' lastname from employee

D. select firstname,lastname from employee

E.