					More programs at www.pranavthegreat.cjb.net


 create view pranav
 as select a.category_id,description,count(book_id) "count_books"
 from catalog c,category a
 where c.category_id=a.category_id
 group by a.category_id,description;


					More programs at www.pranavthegreat.cjb.net
