create table if not exists books( 
bookCount INT,     
title VARCHAR(255) not null,     
author VARCHAR(255) ,     
avg_ratings DOUBLE,   
readDate DATE
)

insert into books values
(1, "The Paper Palace", "Heller, Miranda Cowley",3.93,	'2021-10-16');
insert into books values
(2, "Animal Dreams", "Kingsolver, Barbara", 4.04, '2021-09-30');
insert into books values
(3, "Blue Monday", "French, Nicci", 3.81, '2021-09-13');
insert into books values
(4, "Amy and Isabelle", "Strout, Elizabeth",  	3.86, '2021-08-29');
insert into books values
(5, "The Bean Trees", "Kingsolver, Barbara",	3.98,	'2021-08-11');
insert into books values
(6, "Accidents in the Home", "Hadley, Tessa", 	3.5, '2021-07-30');
