SQLzoo.net

Get the 11th to the 20th rows of the cia table - by population.

Oracle
	SELECT name, population FROM ( SELECT name, population, rownum n FROM ( SELECT name,population FROM cia ORDER BY population DESC) ) WHERE n BETWEEN 11 AND 20
Specific to Oracle
This seems very complicated, seemingly the rownum is calculated after the WHERE clause runs so WHERE rownum>1 always gives zero rows.