现有表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.