select BookId,BookName,Edition,case when BookName like '%C#%' then '500'when BookName like '%Java%' then '450'when BookName like '%OOPS%' then '400' End as Price from Book_details
Login to post response