Listing 2: OUTER APPLY Query That Returns the Two Most Recent Sales Rows for Each 
Store (Sales > 10)

SELECT ST.stor_id, CA.*
FROM dbo.Stores AS ST
  OUTER APPLY
    (SELECT TOP(2) ord_num, title_id, ord_date, qty
     FROM dbo.Sales AS SL
     WHERE SL.stor_id = ST.stor_id AND qty >= 10
     ORDER BY ord_date DESC, ord_num DESC, title_id DESC) AS CA;