bin/create_sql_lab.sql

create table job (
    name text not null,
    credits real not null
);

create table work (
    person text not null,
    job text not null
);

insert into job values
('calibrate', 1.5),
('clean', 0.5);

insert into work values
('Amal', 'calibrate'),
('Amal', 'clean'),
('Amal', 'complain'),
('Gita', 'clean'),
('Gita', 'clean'),
('Gita', 'complain'),
('Madhi', 'complain');