Create view Categories
as Select Category = b.Category, QtySold =coalesce(sum(ordde.Qty), '0'), TotalRevenue = coalesce(sum(ordde.Price * ordde.Qty), '0')
from Book b
left join OrderDetail ordde on b.ISBN = ordde.ISBN
group by b.Category
go