SQL学习-在查询器中建立数据库结构语句

create database AAA
create table A1
(
Id int identity(1,1) primary key,
Name varchar(20),
Sex char(2),
Age int,
Birthday datetime
)

insert into A1(Name,Sex,age,birthday)values ('zhangjie','wo',16,'2000-1-10')
insert into A1(Name,Sex,age,birthday)values ('zhanghua','ma',18,'2000-2-10')
insert into A1(Name,Sex,age,birthday)values ('zhangli','wo',19,'2000-3-10')
insert into A1(Name,Sex,age,birthday)values ('zhangming','ma',20,'2000-4-10')
insert into A1(Name,Sex,age,birthday)values ('zhangtong','ma',21,'2000-5-10')
insert into A1(Name,Sex,age,birthday)values ('zhangfang','wo',16,'2000-1-2')
insert into A1(Name,Sex,age,birthday)values ('zhangjie','ma',30,'2000-1-8')