菜鸟关于SQL查询语句问题

--create table mokao(nam varchar(10),cod varchar(10),tern int,sco numeric(6,2))
--insert into mokao(nam,cod,tern,sco) values('a','1',1,85)
--insert into mokao(nam,cod,tern,sco) values('a','1',2,97)
--insert into mokao(nam,cod,tern,sco) values('a','1',3,85)
--insert into mokao(nam,cod,tern,sco) values('a','1',4,90)

--insert into mokao(nam,cod,tern,sco) values('b','2',1,85)
--insert into mokao(nam,cod,tern,sco) values('b','2',2,97)
--insert into mokao(nam,cod,tern,sco) values('b','2',3,79)
--insert into mokao(nam,cod,tern,sco) values('b','2',4,91)

--insert into mokao(nam,cod,tern,sco) values('c','3',1,85)
--insert into mokao(nam,cod,tern,sco) values('c','3',2,97)
--insert into mokao(nam,cod,tern,sco) values('c','3',3,77)
--insert into mokao(nam,cod,tern,sco) values('c','3',4,97)

select * from mokao where nam in(
 select nam from (select * from mokao where tern >=2 and sco >=80)a
 group by nam having count(*)>=3)

select id as 序号 from 表
也可以
select id 序号 from 表