select 

case 
	when price is null then 'Not Yet Priced'

	when price <10 then 'Below 10'

	when price>=10 and price <=20 then 'price is between 10 to 20'

	else 'price is above 20'

	end

as 'Price Category',title FROM pubs.dbo.titles ORDER BY price