创建视图actor_name_view

创建视图的基本语法是CREATE VIEW view_name AS SELECT column1, column2, ... FROM table_name WHERE condition; 根据题目提示，此时的条件是来源于后台导入的值，所以可以用last_name或first_name进行筛选 CREATE VIEW actor_name_view AS SELECT first_name as first_name_v, last_name as last_name_v FROM actor WHERE last_name in('GUINESS','WAHLBERG');