sqltile创建视图的语句为:
CREATE [TEMP | TEMPORARY] VIEW view_name AS SELECT column1, column2..... FROM table_name WHERE [condition];
参考这个,本题创建视图答案为:
CREATE VIEW actor_name_view AS SELECT first_name first_name_v ,last_name last_name_v FROM actor;
sqltile创建视图的语句为:
CREATE [TEMP | TEMPORARY] VIEW view_name AS SELECT column1, column2..... FROM table_name WHERE [condition];
参考这个,本题创建视图答案为:
CREATE VIEW actor_name_view AS SELECT first_name first_name_v ,last_name last_name_v FROM actor;