下面定义视图的SQL语句，哪一个是错误的？（） A: create view VIEW1 as select id,name,sex from users B: create view VIEW2 as select count(*) as studentTotal,classname from student C: create view VIEW3 as select name,price from D: create view VIEW4 as select logdate,price,1.1*parice as ‘涨价’ from shop

公告：维护QQ群：833371870，欢迎加入！
公告：维护QQ群：833371870，欢迎加入！
公告：维护QQ群：833371870，欢迎加入！

2022-06-07 问题

下面定义视图的SQL语句，哪一个是错误的？（） A: create view VIEW1 as select id,name,sex from users B: create view VIEW2 as select count() as studentTotal,classname from student C: create view VIEW3 as select name,price from D: create view VIEW4 as select logdate,price,1.1parice as ‘涨价’ from shop