以下内容是关于sql insert into 语句使用的求助

Question

向Student表插入一条记录：该记录学号是“1080001”,姓名“李好”，性别与“1080002”相同，专业与“1080003”在同一专业，年龄与“1080005”相同；
student表中字段分别是name,no,age,sex,major
求问语句怎么写

Answer 1

insert into student(name,no,age,sex,major) values('李好','1080001',(select age from student where no='1080005'),(select distinct sex from student where no='1080002'),(select distinct major from student where no='1080003'))