An Error Was Encountered

Error Number: 1054

Unknown column 'specialprice' in 'where clause'

SELECT COUNT(vin) AS totalVehicles FROM inventory i WHERE i.active = 1 AND type = "new" AND (CASE WHEN specialprice = "0" THEN sellingprice ELSE depsellingprice END) BETWEEN 30001 AND 40000