用sql語句創建學生表如何做

? (?? 學號?char(12)?primary?key,?? 姓名?char(6)?not?null,?? 性別?char(2)?check(性別?IN?('男','女')),?? 班級?char(15)?? )

create?table?成績表?? (?? 學號?char(12)references?學生表(學號),?? 課程號?char(2)references?課程表(課程號),?? 成績?int?default(30),?? primary?key?(學號,課程號)?? )?? create?table?課程表?? (?? 課程號?char(2)?primary?key,?? 課程名?char(20),?? 學分?int?check(學分&gt;=1?and?學分<p>相關操作：</p><pre class="brush:sql;toolbar:false">insert?into?學生表?values('201190609112','張xl','男','文專計1111')?? insert?into?學生表?values('201190609113','張**','女','文專計1111')?? insert?into?成績表?values('201190609112','01',100)?? insert?into?成績表?values('201190609112','02',99)?? insert?into?成績表?values('201190609112','03',88)?? insert?into?課程表?values('01','數據庫系統',3)?? insert?into?課程表?values('02','vb.net',4)?? insert?into?課程表?values('03','java',4)?? select?*from?成績表?? select?姓名,課程名,成績??? from?學生表,課程表,成績表??? where?(學生表.學號=成績表.學號?and?課程表.課程號=成績表.課程號)?? order?by?成績?desc?? select?avg(成績)?平均分,max(成績)?最高分,min(成績)?最低分?? from?成績表?? where?學號='201190609112