创建”上海“队的运动员视图的正确选项是()。
A、CREATE TABLE SH_A AS SELECT 运动员编号,姓名,性别 FROM 运动员 WHERE 队别='上海';
B、CREATE VIEW SH_A SELECT 运动员编号,姓名,性别 FROM 运动员 WHERE 队别='上海';
C、CREATE VIEW SH_A (SH_NO, SH_NAME, SH_SEX) SELECT 运动员编号,姓名,性别 FROM 运动员 WHERE 队别='上海';
D、CREATE VIEW SH_A AS SELECT 运动员编号,姓名,性别 FROM 运动员 WHERE 队别='上海';