I am doing a GIS project analyzing rooftops. I need to isolate North, Northwest, and Northeast facing rooftops. I've had success using the CON tool for other raster layers, but whenever I try to use the CON tool on the aspect raster, it fails. I think it is because I am inputting the SQL expression incorrectly. I have included images of the symbology menu and the error box.
I have tried multiple variations of the following SQL expression: VALUE = 'North(0-22.5)' OR VALUE = 'Northeast (22.5-67.5)' OR VALUE = 'Northwest (292.5-337.5)' OR VALUE = 'North (337.5-360)'
I have also tried writing the expression with the numerical values for example Northeast is all values between 22.5 and 67.5.