File size: 376 Bytes
aaef24a
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
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');