单项选择题

A、CREATE VIEW myview SELECT*FROM歌手WHERELIKE(“1”歌手号)
B、CREATE VIEW myview ASSELECT*FROM歌手WHERELIKE(“1”歌手号)
C、CREATE VIEW myview SELECT*FROM歌手WHERELEFT(歌手号,1)=“1”
D、CREATE VIEW myview ASSELECT*FROM歌手WHERELEFT(歌手号,1)="1"