题目:针对actor表创建视图actor_name_view,只包含first_name以及last_name两列,并对这两列重新命名,first_name为first_name_v,last_name修改为last_name_v:

创建视图view的代码是

create view 视图名 as 旧的表格

旧的表格需要用select的格式提取需要展示的内容

以上。

create view actor_name_view as 
(select first_name as first_name_v, last_name as last_name_v from actor )