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 sex from Student where no='1080002'),
(select major from Student where no='1080003'))