[RESOLVED] Conditional Query

[TheBigB]

So in the attached database there is a table AIRPORT that contains airportnames, the state where they are located and the opening year.

The exercise goes as follows:
Return the number of airports opened after 1935. Only count the airports of which at least 5 exist in the state (all opened after 1935).
I know the answer is 0 because the table is not that big, but how could I construct a query that retrieves that?

Query w11g in the database contains what I could figure out.
(note: I'm using 1900 there as 1935 doesn't have any results)

Thanks

[TheBigB]

And nevermind.
Solved it

SELECT sum(RET) 
FROM

(SELECT count(*) AS RET
 FROM AIRPORT
 WHERE int(AIRPORT.YEAROPENED)>=1900
 GROUP BY AIRPORT.STATE) 

WHERE RET >=5;

I'm starting to like this SQL stuff