How do I write script with case

See more:

SQL

server

I wrote Sql Server query for northwind

I want output without null values

What I have tried:

use Northwind
select productid, productname,
case
when unitsinstock >100 then 'no order'
when unitsinstock between 1 and 10 then 'yes order'
end AS reorder_need
from Products