MS SQL 에는 DUAL 이 없다.

http://joshua90.tistory.com/12

SELECT  '30대' AS ageGroup, SUM(scope) AS scope
FROM     (SELECT  COUNT(*) AS scope, birthDay
                FROM     Pie
                WHERE  (birthDay BETWEEN 1982 AND 1992)
                GROUP BY birthDay) AS virtualTable