ebasio

SELECT TOP(50) g.Name AS Name,
               FORMAT(g.Start, 'yyyy-MM-dd') AS Start
  FROM Games AS g
 WHERE DATEPART(YEAR, g.Start) IN (2011, 2012)
ORDER BY g.Start ASC,
         g.Name ASC