下面定义视图的SQL语句，哪一个是错误的？（ ）

A. create view1 as select id,name,sex from users
B. create view2 as select count(*) as studentTotal,classname from student
C. create view3 as select name,price from
D. create view4 as select logdate,price,1.1*parice as ‘涨价’ from shop