COUNT (case when)

#1 



Hi there,

I am just wondering, it's possible to achieve the same result with following code?

SELECT state, COUNT (*) 
FROM airports 
WHERE elevation < 1000 AS count_high_elevation_aiports 
GROUP BY state;

Thanks!

#2

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