SQLize Online / PHPize Online  /  SQLtest Online

-- Hint: use Ctrl+Enter for SQL autocomplete create table student ( student_id serial primary key, name text not null ); create table class ( class_id serial primary key, name text not null ); create table student_class ( student_class_id serial primary key, student_id integer not null references student(student_id), class_id integer not null references class(class_id), class_date date not null ); insert into student (name) values('Harry Potter'); insert into student (name) values('Hermione Granger'); insert into student (name) values('Ron Weasley'); insert into student (name) values('Draco Malfoy'); insert into class (name) values('Charms'); insert into class (name) values('Potions'); insert into class (name) values('Herbology'); insert into class (name) values('Divinition'); insert into student_class(student_id, class_id, class_date) values(1,1,'2015-08-02'); insert into student_class(student_id, class_id, class_date) values(2,1,'2015-08-03'); insert into student_class(student_id, class_id, class_date) values(3,2,'2015-08-02'); insert into student_class(student_id, class_id, class_date) values(4,2,'2015-08-04'); insert into student_class(student_id, class_id, class_date) values(2,2,'2015-08-03'); insert into student_class(student_id, class_id, class_date) values(1,1,'2015-08-02'); insert into student_class(student_id, class_id, class_date) values(3,2,'2015-08-04'); insert into student_class(student_id, class_id, class_date) values(4,3,'2015-08-03'); insert into student_class(student_id, class_id, class_date) values(1,4,'2015-08-02'); insert into student_class(student_id, class_id, class_date) values(3,1,'2015-08-02'); insert into student_class(student_id, class_id, class_date) values(4,2,'2015-08-04'); insert into student_class(student_id, class_id, class_date) values(3,2,'2015-08-02'); insert into student_class(student_id, class_id, class_date) values(1,1,'2015-08-02'); insert into student_class(student_id, class_id, class_date) values(4,3,'2015-08-03'); select * from student; select * from class; select * from student_class;