3/8 Conditional Aggregates Table Transformation


#1

Hey,

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.

Kindest regards

Lauren

https://www.codecademy.com/courses/sql-table-transformation/lessons/conditional-aggregates/exercises/case-when?action=lesson_resume&link_content_target=interstitial_lesson


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
;


#2

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.