SQLize Online / PHPize Online  /  SQLtest Online

create table students (sname text, sid int primary key, gpa float); create table courses(cname text, cid int primary key); create table enrollment(sid int, cid int); alter table enrollment add constraint foreign key sid references students; insert into students values ('Ruven', 1, 3.3); insert into students values ('Alex', 2, 3); insert into students values ('Sarah', 3, 4); insert into students values ('Matt', 4, 2.5); insert into students values ('Ang', 5, 3.5); insert into courses values ('2800', 1); insert into courses values ('3110', 2); insert into courses values ('4820', 3); insert into enrollment values (1, 1);