create table book(bid int, bname varchar(25),author varchar(20),price decimal (6,2),catid int);

insert into book values(1,"Programming in C","balaguruswamy",350,11);
insert into book values(2,"Digital Electronics","Floyd",480,12);
insert into book values(3, "Great expectation","Charles Dickens",300,14);
insert into book values(4, "Wings of fire","APJ Abdul kalam",550,16);
select * from book;


create table category(cid int, description  varchar(25));

insert into category values(11, "Programming");
insert into category values(12,"Electronics");
insert into category values(13,"History");
insert into category values(14,"Fiction");
select * from category;

select * from book order by bname;
select * from book order by price desc;
select bname, author, price, description from book inner join category on book.catid=category.cid;
select bname, author, price, description from book left join category on book.catid=category where description is NULL;