SQL練習38:actorテーブルのビューactorを作成するname_view

CREATE TABLE  actor  (
   actor_id  smallint(5)  NOT NULL PRIMARY KEY,
   first_name  varchar(45) NOT NULL,
   last_name  varchar(45) NOT NULL,
   last_update datetime NOT NULL);

CREATE VIEW actor_name_view AS 
SELECT first_name AS first_name_v, last_name AS last_name_v 
FROM actor

CREATE VIEW actor_name_view (first_name_v, last_name_v) AS
SELECT first_name, last_name FROM actor