Skip to content
The Chat Archive
gpt-3.5-turbo-0301· OpenAI WildChat-4.8M (AI2)

视图练习 1.填空题 实验:在数据库schooldb中,创建和应用视图①创建视图。统计每位同学所有课程的总分,显示学号、姓名和总分列。 select…

  1. User

    视图练习 1.填空题 实验:在数据库schooldb中,创建和应用视图①创建视图。统计每位同学所有课程的总分,显示学号、姓名和总分列。 select student.studentno as 学号,studentname as 姓名,sum(studentresult) as总分 from student inner join_ on() group by student.; create. fs_view as select student.studentno as学号,studentname as 姓名,sum(studentresult) as总分 from student inner join on(_____) group by student.______; show create view fs_view;

  2. Assistant

    实验:在数据库schooldb中,创建和应用视图 ①创建视图。统计每位同学所有课程的总分,显示学号、姓名和总分列。 select student.studentno as 学号,studentname as 姓名,sum(studentresult) as 总分 from student inner join score on student.studentno = score.studentno group by student.studentno;

    create view fs_view as select student.studentno as 学号, studentname as 姓名, sum(studentresult) as 总分 from student inner join score on student.studentno = score.studentno group by student.studentno;

    show create view fs_view;

  3. User

    视图练习 1.填空题 实验:在数据库schooldb中,创建和应用视图①创建视图。统计每位同学所有课程的总分,显示学号、姓名和总分列。 select student.studentno as 学号,studentname as 姓名,sum(studentresult) as总分 from student inner join_ on() group by student.____; create. _fs_view as select student.studentno as学号,studentname as 姓名,sum(studentresult) as总分 from student inner join on(_) group by student._____; show create view fs_view;

  4. Assistant

    实验:在数据库schooldb中,创建和应用视图 ①创建视图。统计每位同学所有课程的总分,显示学号、姓名和总分列。 select student.studentno as 学号,studentname as 姓名,sum(studentresult) as 总分 from student inner join score on student.studentno = score.studentno group by student.studentno;

    create view fs_view as select student.studentno as 学号, studentname as 姓名, sum(studentresult) as 总分 from student inner join score on student.studentno = score.studentno group by student.studentno;

    show create view fs_view;