test.sql

create table student (                                                                     
provtuple varchar(10),
name varchar(20),
age integer,
major varchar(20)
);
create table regu (
provtuple varchar(10),
name varchar(20),
courseid integer
);
insert into student values ('t1', 'jhon', 20, 'cs'), ('t2', 'mike', 21, 'cs'), ('t3', 'jack', 22, 'ece');
 insert into regu values ('t1', 'jhon', 17), ('t2', 'jhon', 19), ('t3', 'mike', 21), ('t4', 'jack', 15), ('t5', 'jack', 19);