classwork/db_data.sql at main · christudo/classwork · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
insert into authors (first_name, last_name) values ('William', 'Shakespeare');
insert into authors (first_name, last_name) values ('Charlotte', 'Bronte');
insert into authors (first_name, last_name) values ('Harper', 'Lee');
insert into authors (first_name, last_name) values ('Jane', 'Austen');
insert into authors (first_name, last_name) values ('Walter', 'Isaacson');
insert into authors (first_name, last_name) values ('Frank', 'Herbert');

insert into genres values (default, 'Fantasy');
insert into genres values (default, 'Biography');
insert into genres values (default, 'Science Fiction');
insert into genres values (default, 'Fiction');
insert into genres values (default, 'Thriller');
insert into genres values (default, 'Documentary');

insert into books values (default, 'Dune', 1, 1965);
insert into books values (default, 'Steve Jobs', 2, 2011);
insert into books values (default, 'Pride and Prejuidice', 4, 1813);
insert into books values (default, 'To Kill a Mockingbird', 4, 1965);

insert into authors_books values (default, 5, 2 );
insert into authors_books values (default, 6, 1 );
insert into authors_books values (default, 4, 3 );
insert into authors_books values (default, 3, 4 );