1. a subquery containing the order by clause that ensures that the rows
retrieved by the subquery are placed in the proper order;
2. the main query that includes the ROWNUM pseudo-attribute and may include
a where clause to specify the number of returned rows.