Thank you in advance for any help you can give. I am on 3/8 Conditional Aggregates Table Transformation. I have written out the code and I am getting the results and have followed the instructions, im not getting an error message but it just wont accept the code...
please let me know if you can see where I am going wrong.. I have listed my code below.
SELECT CASE WHEN elevation > 250 THEN 'Low' WHEN elevation between 250 and 1749 THEN 'Medium' WHEN elevation >= 1750 THEN 'HIGH' ELSE 'Unknown' END as elevation_tier, COUNT (*) FROM AIRPORTS GROUP BY 1 ;