一道sql面试题

假设有以下3张表 create table course ( `id` integer primary key, `name` text not null ); create table student ( `id` integer primary key, `name` text not null ); create table score ( `id` integer primary key, `course_id` integer not null, `student_id` integer not null, `score` integer not null ); 初始化以下数据 -- insert insert into course values (1, &...

周六 · 2024-08-31 · 2 分钟 · Yuechen